请问下，如何往储存过程中传入‘，’的字符串

[waitinglines]

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO




------------------------------------
--用途：增加一条记录
--项目名称：
--说明：
--时间：2008-3-5 15:18:35
------------------------------------
ALTER PROCEDURE UP_Questions_ADD
@itemid int ,
@itemValue varchar(1000)

AS
INSERT INTO Questions(
[author],[Q_Note],[Q_Content],[ImageName],[HiteCounter],[AnsCounter],[ReleaseTime],[ReferTime],[BigClass_ID],[SmallClass_ID],[kind],[solved]
) select top 20 'waitingline' as author,title,content,
photourl,
'0' as HiteCounter,
'0' as AnsCounter,
getdate() as ReleaseTime,
getdate() as ReferTime,
(select bigclassid from zl_collitem where zl_collitem.[id]=zl_collection.itemid) as BigClass_ID,
(select smallclassid from zl_collitem where zl_collitem.[id]=zl_collection.itemid) as smallclass_ID,
'1' as kind,
'0' as solved from zl_collection
where itemid=@itemid and [id] in (@itemValue)

delete from zl_collection where itemid=@itemid and [id] in (@itemValue)


服务器: 消息 245，级别 16，状态 1，过程 UP_Questions_ADD，行 16
将 varchar 值 '19,20' 转换为数据类型为 int 的列时发生语法错误。










GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

[pt1314917]

ALTER     PROCEDURE UP_Questions_ADD 
@itemid int , 
@itemValue varchar(1000) 

AS  
INSERT INTO Questions( 
 [author],[Q_Note],[Q_Content],[ImageName],[HiteCounter],[AnsCounter],[ReleaseTime],[ReferTime],[BigClass_ID],[SmallClass_ID],[kind],[solved] 
)  select top 20  'waitingline' as author,title,content, 
photourl, 
'0' as HiteCounter, 
 '0' as AnsCounter,  
getdate() as ReleaseTime, 
          getdate() as ReferTime, 
(select bigclassid from zl_collitem where zl_collitem.[id]=zl_collection.itemid) as BigClass_ID, 
(select smallclassid from zl_collitem where zl_collitem.[id]=zl_collection.itemid) as smallclass_ID, 
'1' as kind, 
'0' as solved from zl_collection  
where itemid=@itemid and 
--[id] in (@itemValue) 改为
charindex(','+ltrim(id)+',',','+@itemValue+',') >0

delete from zl_collection  where itemid=@itemid and  
--[id] in (@itemValue)改为
charindex(','+ltrim(id)+',',','+@itemValue+',')>0 

[-狙击手-]

ALTER     PROCEDURE UP_Questions_ADD 
@itemid int , 
@itemValue varchar(1000) 

AS  
INSERT INTO Questions( 
 [author],[Q_Note],[Q_Content],[ImageName],[HiteCounter],[AnsCounter],[ReleaseTime],[ReferTime],[BigClass_ID],[SmallClass_ID],[kind],[solved] 
)  select top 20  'waitingline' as author,title,content, 
photourl, 
'0' as HiteCounter, 
 '0' as AnsCounter,  
getdate() as ReleaseTime, 
          getdate() as ReferTime, 
(select bigclassid from zl_collitem where zl_collitem.[id]=zl_collection.itemid) as BigClass_ID, 
(select smallclassid from zl_collitem where zl_collitem.[id]=zl_collection.itemid) as smallclass_ID, 
'1' as kind, 
'0' as solved from zl_collection  
where itemid=@itemid and charindex(','+[id]+',',','+@itemValue+',') > 0 

delete from zl_collection  where itemid=@itemid and  charindex(','+[id]+',',','+@itemValue+',') > 0 

[-狙击手-]

更正一下，id => rtrim(id)

[-狙击手-]

更正一下，id => rtrim(id)

[utpcb]

分数太少了呵呵

[waitinglines]

呵呵，本人刚来，分数比较少！