请问这个存储过程该怎么写

[hideboy]

update Table1 set Value = @Value where Table_ID in (1,2)

我想使用存储过程的参数替换“1，2”

@ID_List [varchar](255)

update Table1 set Value = @Value where Table_ID in (@ID_List)

可是使用的时候就说不能转换成int,大家帮我看看怎么改

[txlicenhe]

try:

@ID_List [varchar](255)

exec('update Table1 set Value = ' + cast(@Value as varchar) + ' where Table_ID in (' + @ID_List + ')')

[yujohny]

create proc test (@ID_List varchar(255))
as
exec('update Table1 set Value = '''+@Value+'''
where Table_ID in ('+@ID_List+')')

[friendliu]

exec('update Table1 set Value = '''+@Value+'''
where Table_ID in ('+@ID_List+')

[zjcxc]

@ID_List [varchar](255)

exec('update Table1 set Value = '''+@Value+''' where Table_ID in ('+@ID_List+')')

[zjcxc]

或:


@ID_List [varchar](255)

update Table1 set Value = @Value where charindex(','+cast(Table_ID as varchar)+',',','+@ID_List+',')>0

[hideboy]

好，行了，谢谢各位，不过这种写发好奇怪，不习惯。
稍后给分