DECLARE @SqlString nvarchar(MAX)
DECLARE @SqlString2 VARCHAR (100)
SET @SqlString2='1,2,3,4';
SET @SqlString='UPDATE xxx
SET
[type] = 1
WHERE ID IN ('+@SqlString2+')';
EXEC sp_executesql @SqlString
DECLARE @SqlString2 VARCHAR (100)
SET @SqlString2='1,2,3,4';
SET @SqlString='UPDATE xxx
SET
[type] = 1
WHERE ID IN ('+@SqlString2+')';
EXEC sp_executesql @SqlString
以备不时之需