第1个回答 2010-10-17
declare @works varchar(128)
declare @sql varchar(128)
declare c1 cursor for
select work from A
open c1
fetch next from c1 into @works
while @@fetch_status = 0
begin
set @sql = 'update B
set source=replace(source,'''+ @works + ''','')'
exec(@sql)
fetch next from c1 into @works
end
close c1
deallocate c1