sql server 处理多个字段值以逗隔开的查询条件

CREATE TABLE #table(
id VARCHAR(2),
name NVARCHAR(10),
note NVARCHAR(200)
)


INSERT INTO #table(id,name,note)
(
SELECT 'aa','张三','' UNION ALL
SELECT 'bb','王五','' UNION ALL
SELECT 'cc','赵六','' 
)


DECLARE @value VARCHAR(50)
set @value='张三,王五,赵六'


DECLARE @sql VARCHAR(100)
SET @sql='select id from #table where name in('''+REPLACE(@value,',',''',''')+''')'


PRINT(@sql)
EXEC(@sql)

DROP TABLE #table

输出：

id

1 aa

2 bb

3 cc