DECLARE @Table1 TABLE (a NVARCHAR(4),b INT)
INSERT INTO @Table1 VALUES('0001',1)
INSERT INTO @Table1 VALUES('0002',2)
INSERT INTO @Table1 VALUES('0003',3)
DECLARE @DWList NVARCHAR(400)
SET @DWList ='''0001'',''0002'''
select * from @Table1 where CHARINDEX(','''+a+''',',','+@DWList+',')>0
1,Exec('select * from tbname where dm in ( '+@DWList+' )')不可行因为tbname为临时表
我还需要处理。
2,select * from tbname where Charindex(','+dm+',',','+@DWList+',')>0 好像也出不来。