CREATE PROC test (@input varchar(100))
ASEXEC ('SELECT DISTINCT si.item_Id
FROM dbo.hl_ExamSession s INNER JOIN
dbo.hl_ES_Item si ON s.examSession_Id = si.examSession_Id
WHERE (s.class_Id IN ('+@input+'))')go--
EXEC test '1, 2, 3'
ASEXEC ('SELECT DISTINCT si.item_Id
FROM dbo.hl_ExamSession s INNER JOIN
dbo.hl_ES_Item si ON s.examSession_Id = si.examSession_Id
WHERE (s.class_Id IN ('+@input+'))')go--
EXEC test '1, 2, 3'
...s.class_Id IN (@参数1, @参数2, @参数3))如果想参数不定,那么参数用表即可,相应语句为:
...s.class_Id IN (select id from @表))