SQLSERVER2000
存储过程:
CREATE PROCEDURE [update_d_gunrecord1_1]
(@gunid_3 [varchar](200) )AS UPDATE [yayun_system].[dbo].[d_gunrecord1]
SET [sf]= 1,[rtime]=getdate()WHERE
( [gunid] in (@gunid_3))
GO现在有一个变量STR:='''A'',''B'',''C'''
把STR传递给@gunid_3 时出现错误:“太多的参数”,原来SQLSERVER认为我传递了'a','b','c'三个参数给他,但实际上是一个整体!
怎么办啊?
谢谢!
存储过程:
CREATE PROCEDURE [update_d_gunrecord1_1]
(@gunid_3 [varchar](200) )AS UPDATE [yayun_system].[dbo].[d_gunrecord1]
SET [sf]= 1,[rtime]=getdate()WHERE
( [gunid] in (@gunid_3))
GO现在有一个变量STR:='''A'',''B'',''C'''
把STR传递给@gunid_3 时出现错误:“太多的参数”,原来SQLSERVER认为我传递了'a','b','c'三个参数给他,但实际上是一个整体!
怎么办啊?
谢谢!
STR:='''''''A'''',''''B'''',''''C'''''''
看看(实际是:'''A'',''B'',''C''')