如果ItemNum 是数字型的话,可以直接这样就可以
select * from table1 where ItemNum in (1,2,3,5,9,1025)那么可以这么改
declare @str Varchar(100)
Set @str='1,2,3,5,9,1025'
Exec('select * from T1 Where LID IN ('+@str+')')
select * from table1 where ItemNum in (1,2,3,5,9,1025)那么可以这么改
declare @str Varchar(100)
Set @str='1,2,3,5,9,1025'
Exec('select * from T1 Where LID IN ('+@str+')')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货