22,206
社区成员
发帖
与我相关
我的任务
分享
create table aa_20100804
(
id int identity(1,1),
df nvarchar(80)
)
declare @id nvarchar(80)
set @id ='4,5,6'
declare @df nvarchar(80)
set @df='dfdd'
update aa_20100804 set df='awdfsadf' where charindex( ','+ltrim(id)+',',','+@id+',')>0
--或者
--update aa_20100804 set df='awdfsadf' where ','+@id+',' like '%,'+ltrim(id)+',%'
insert into aa_20100804(df) values('a')
select * from aa_20100804
exec('insert into xx where id in('+@id+')')
exec('insert into xx where id in('+@id+')')