110,537
社区成员
发帖
与我相关
我的任务
分享
declare @parm as varchar ( 5000) , @sql as varchar ( 5000 )
set @parm = '1\2\3'
set @parm = replace ( @parm , '\' , ' and proid=' )
set @sql = 'select * from testa where proid=' + @parm
print @sql
/*输出结果 select * from testa where proid=1 and proid=2 and proid=3*/