这个触发器插入到动态表中，为什么总是不对？

chenfeg 2007-11-08 01:50:29

exec('insert INTO'+ @tbl_name+'(SM_Type, SM_ID, SubTime, OrgAddr, DestAddr, SM_Content, SendTime, MsgID, Service_ID, Fee_UserType, Fee_Terminal_ID, Msg_Fmt, FeeType, FeeCode, Valid_Time, Sent_Time, Msg_Status, TryTimes, Recv_Status, Recv_Time, CreatorID, SMType, MessageID, DestAddrType)'
+'select (0, 1,'+@sendtime+','+@OrgAddr+','+ @DestAddr+','+@SM_Content+','+@sendtime+', 0,''EIE'', 0, 0, 0, 0, 0,'+@sendtime+','+@sendtime+', 0, 0, 0,'+@sendtime+',@CreatorID, 0, 0, 0)')
end

服务器: 消息 170，级别 15，状态 1，行 1
第 1 行: ',' 附近有语法错误。

...全文

48 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

-狙击手- 2007-11-08

打赏
举报

exec( 'insert INTO '+
@tbl_name+ '(SM_Type, SM_ID, SubTime, OrgAddr, DestAddr, SM_Content, SendTime, MsgID,
Service_ID, Fee_UserType, Fee_Terminal_ID, Msg_Fmt, FeeType, FeeCode, Valid_Time,
Sent_Time, Msg_Status, TryTimes, Recv_Status, Recv_Time, CreatorID, SMType,
MessageID, DestAddrType) '

+ 'select 0, 1, '+@sendtime+ ', '+@OrgAddr+ ', '+
@DestAddr+ ', '+@SM_Content+ ', '+@sendtime+ ', 0,'+ '''EIE '''+', 0, 0, 0, 0, 0, '+@sendtime+ ', '
+@sendtime+ ', 0, 0, 0, '+@sendtime+ ','+@CreatorID+', 0, 0, 0 ')

昵称被占用了 2007-11-08

打赏
举报

exec( 'insert INTO '+ @tbl_name+ '(SM_Type, SM_ID, SubTime, OrgAddr, DestAddr, SM_Content, SendTime, MsgID, Service_ID, Fee_UserType, Fee_Terminal_ID, Msg_Fmt, FeeType, FeeCode, Valid_Time, Sent_Time, Msg_Status, TryTimes, Recv_Status, Recv_Time, CreatorID, SMType, MessageID, DestAddrType) '
+ 'select 0, 1, '+@sendtime+ ', '+@OrgAddr+ ', '+ @DestAddr+ ', '+@SM_Content+ ', '+@sendtime+ ', 0, ''EIE '', 0, 0, 0, 0, 0, '+@sendtime+ ', '+@sendtime+ ', 0, 0, 0, '+@sendtime+ ','+@CreatorID+', 0, 0, 0 ' )