注册 登录
编程论坛 SQL Server论坛

一个小问题 急求大家帮忙

lovellq39 发布于 2007-12-29 10:34, 932 次点击
INSERT INTO T_User
      (UserId, CompanyId, CompanyName, PortCode, PortAddName, PortAdd, StreeNo,
      BuildNo, BuildUnit, BuildRoom, CustomCardId, CustomName, CustomPhoneNo,
      Moblie, PortCont, PortState, DredgeDate, HouseAttribute, CustomCardType,
      NowUptoYear, NowUptoMonth, CustomLevel, CustomGroup, CustomType, TronKind,
      BuildDate, AllPortCount)
SELECT (UserId,CompanyId,CompanyName,PortCode,PortAddName,PortAdd,StreeNo,
      BuildNo,BuildUnit,BuildRoom,CustomCardId,CustomName,CustomPhoneNo,
      Moblie,PortCont,PortState,DredgeDate,HouseAttribute,CustomCardType,
      NowUptoYear,NowUptoMonth,CustomLevel,CustomGroup,CustomType,TronKind,
      BuildDate,AllPortCount)
FROM T_user


老提示
服务器: 消息 170,级别 15,状态 1,行 7
第 7 行: ',' 附近有语法错误。
   我来找不出来请大家帮忙
3 回复
#2
wyg48592007-12-29 10:48
确保行与行之间没有空格
#3
西风独自凉2007-12-29 11:00
INSERT INTO T_User
      (UserId, CompanyId, CompanyName, PortCode, PortAddName, PortAdd, StreeNo,
      BuildNo, BuildUnit, BuildRoom, CustomCardId, CustomName, CustomPhoneNo,
      Moblie, PortCont, PortState, DredgeDate, HouseAttribute, CustomCardType,
      NowUptoYear, NowUptoMonth, CustomLevel, CustomGroup, CustomType, TronKind,
      BuildDate, AllPortCount)
SELECT UserId,CompanyId,CompanyName,PortCode,PortAddName,PortAdd,StreeNo,
      BuildNo,BuildUnit,BuildRoom,CustomCardId,CustomName,CustomPhoneNo,
      Moblie,PortCont,PortState,DredgeDate,HouseAttribute,CustomCardType,
      NowUptoYear,NowUptoMonth,CustomLevel,CustomGroup,CustomType,TronKind,
      BuildDate,AllPortCount
FROM T_user
#4
西风独自凉2007-12-29 11:00
選擇出的字段用括號括起來,有這樣用的
1