基本信息，您将在这里找到: ^ ]

下面，示例代码应该可以工作:

Basic information, you''ll find here: http://msdn.microsoft.com/en-us/library/ms177682.aspx[^]

Below, example code should works:

CREATE TABLE #tof(case_status INT)

INSERT INTO #tof(case_status)
VALUES (1)
INSERT INTO #tof(case_status)
VALUES (2)
INSERT INTO #tof(case_status)
VALUES (3)
INSERT INTO #tof(case_status)
VALUES (4)
INSERT INTO #tof(case_status)
VALUES (5)

DECLARE @status_code NVARCHAR(300)
DECLARE @sql_query NVARCHAR(300)

SET @status_code='1, 2'
SET @sql_query = 'SELECT * ' +
                'FROM #tof ' +
                'WHERE case_status IN (' + @status_code + ')'
EXEC (@sql_query)

DROP TABLE #tof