请看一下这个存储过程有什么问题？在线等待

[w68j17]

@DWList varchar(4000) --输入参数 如 '001',‘002’，‘003’

select * from tbname where dm in ( @DWList )

为什么不能返回结果！？

[97866]

Exec('select * from tbname where dm in ( '+@DWList+' )')
或
select * from tbname where Charindex(','+dm+',',','+@DWList+',')>0

[pengdali]

select * from tbname where Charindex(','+dm+',',','+@DWList+',')>0

[txlicenhe]

select * from tbname where Charindex(','+dm+',',','+@DWList+',')>0

[yujohny]

这样写存储过程
ALTER PROC aa (@DWList NVARCHAR(400))
AS
EXEC('SELECT * FROM dbo.BOM_main WHERE 清单编号 IN ('+@DWList+')')

这样调用过程
EXEC aa '''001'',''002'',''003'''

[w68j17]

1,Exec('select * from tbname where dm in ( '+@DWList+' )')不可行因为tbname为临时表
我还需要处理。
2，select * from tbname where Charindex(','+dm+',',','+@DWList+',')>0 好像也出不来。

[yujohny]

DECLARE @DWList NVARCHAR(400)

SET @DWList ='''001'',''002'',''003'''

select @DWList

EXEC('SELECT * FROM tbname WHERE dm IN ('+@DWList+')')

[w68j17]

1,@DWList输入值为'''001'',''002'',''003'''
2,我需要从tb1中筛选数据insert到＃tmp中然后对＃tmp进行处理

[yujohny]

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 ','+@DWList+',' LIKE '%,'''+a+''',%'

[yujohny]

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

[zclxyh]

这个是对的
DECLARE @DWList NVARCHAR(400)

SET @DWList ='''001'',''002'',''003'''

select @DWList

EXEC('SELECT * FROM tbname WHERE dm IN ('+@DWList+')')

[w68j17]

感谢各位！！！我已经解决
我将＃tmp改成在存储过程Create table ＃tmp
然后EXEC('insert into #tmp...')