用动态SQL:
DECLARE @windows VARCHAR(40)
SET @windows='12,13'
DECLARE @SQL VARCHAR(400)
SET @SQL='SELECT * FROM TABLENAME WHERE workid in(' + @windows + ')'EXEC (@SQL)
DECLARE @windows VARCHAR(40)
SET @windows='12,13'
DECLARE @SQL VARCHAR(400)
SET @SQL='SELECT * FROM TABLENAME WHERE workid in(' + @windows + ')'EXEC (@SQL)
问题也可能是,@windows 的数据类型不对造成的