该语句问题出在那里呀?

[yuyipj]

set @SQLString='INSERT INTO '+@s_ip+' VALUES ('
+'"'+@FID+'",'
+cast(@FAction as varchar)+','
+cast(@FnTable as varchar)+',"'+@F_TimeStamp+'",'+'"'+@FMac+'",'+'"'+@FProtocol+'",'+
+'"'+@FSrc_Ip+'",'+cast(@FSrc_Port as varchar)+',"'+@FDst_Ip+'",'+cast(@FDst_Port as varchar)+','+cast(@FnFlag as varchar)
+')'

[yujohny]

注意不是"号而是''

[zjcxc]

字符串定界符的问题,SQL中用单引号.
改:
set @SQLString='INSERT INTO '+@s_ip+' VALUES ('''
+@FID+''',' +cast(@FAction as varchar)+','
+cast(@FnTable as varchar)+','''+@F_TimeStamp
+''','''+@FMac+''','''+@FProtocol
+''','''+@FSrc_Ip+''','+cast(@FSrc_Port as varchar)
+','''+@FDst_Ip+''','+cast(@FDst_Port as varchar)
+','+cast(@FnFlag as varchar)+')'

[zjcxc]

字符串定界符的问题,SQL中用单引号.
改:
set @SQLString='INSERT INTO '+@s_ip+' VALUES ('''
+@FID+''',' +cast(@FAction as varchar)+','
+cast(@FnTable as varchar)+','''+@F_TimeStamp
+''','''+@FMac+''','''+@FProtocol
+''','''+@FSrc_Ip+''','+cast(@FSrc_Port as varchar)
+','''+@FDst_Ip+''','+cast(@FDst_Port as varchar)
+','+cast(@FnFlag as varchar)+')'

[yujohny]

推荐你一个方法，
在这句语句后加一个select @sqlstring语句
这样你就可以测试看看是不是你想得到的语句

[CrazyFor]

把你所有的双引号改成两个单引号.即:"改成''

[lfengxu]

所有的双引号改成两个单引号.即:"改成''