@strclassid nvarchar(100)=''SELECT * FROM table1 WHERE charindex(','+cast(parentid as varchar)+',',','+@strclassid+',')>0
--还可以这样@strclassid nvarchar(100)=''exec('SELECT * FROM table1 WHERE parentid IN ('+@strclassid+')')
@strclassid nvarchar(100)=''SELECT * FROM table1 WHERE charindex(','+cast(parentid as varchar)+',',','+@strclassid+',')>0 按照这种方法解决了,非常感谢!!!! 倾家荡产散分,人人都有 :)
按照这种方法解决了,非常感谢!!!!
倾家荡产散分,人人都有 :)