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 行: ',' 附近有语法错误。   我来找不出来请大家帮忙

确保行与行之间没有空格

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

選擇出的字段用括號括起來，有這樣用的