34,587
社区成员
发帖
与我相关
我的任务
分享
declare @ss varchar(20)
set @ss='2'
declare @sql varchar(100)
set @sql=''
set @sql='delete from course where C# in ('+@ss+')'
exec(@sql)
declare @ss varchar(20)
set @ss='2'
declare @sql varchar(100)
set @sql=''
set @sql='delete from course where C# in ('+@ss+')'
exec(@sql)
declare @ss varchar(20)
set @ss='2'
declare @sql varchar(100)
set @sql=''
set @sql='delete from course where C# in ('+@ss+')'
exec(@sql)
declare @ss varchar(50),@sql varchar(max);
set @ss='1,2,3,4';
set @sql='delete from ClassTable where ClassId not in ('+@ss+')';
exec(@sql);
--@ss是字符串,你那样写是按一个字符串'1,2,3,4'而不是一个集合