declare @qnn nvarchar(4000)
set @qnn='INSERT INTO HUAWEI(TMNO,TM02) VALUES('AA','0')
INSERT INTO HUAWEI(TMNO,TM02) VALUES('CA','0') INSERT INTO HUAWEI(TMNO,TM02) VALUES('DA','0')'
exec [HUAWEI_INSERTbatch] @insertbachsql=@qnn
要怎么改呢,谢谢
...全文
2962打赏收藏
SQL变量赋值,值有括号与单引号,提示语法错误,
declare @qnn nvarchar(4000) set @qnn='INSERT INTO HUAWEI(TMNO,TM02)VALUES('AA','0') INSERT INTO HUAWEI(TMNO,TM02)VALUES('CA','0')INSERT INTO HUAWEI(TMNO,TM02)VALUES('DA','0')' exec [HUAWEI_INSERTbatch] @insertbachsql=@qnn 要怎么改呢,谢谢
set @qnn='INSERT INTO HUAWEI(TMNO,TM02) VALUES(''AA'',''0'')
INSERT INTO HUAWEI(TMNO,TM02) VALUES(''CA'',''0'')
INSERT INTO HUAWEI(TMNO,TM02) VALUES(''DA'',''0'')'