如果物料编码只是A,要替換成B,用下面的就可以了,
declare @i varchar(100)
declare @j varchar(20)
declare c1 cursor scroll for
select [name] from sysobjects where [id] in (select [id] from syscolumns where [name]='物料编码')
open c1
fetch first from c1 into @j
while @@fetch_status=0
begin
set @i= 'update '+@j+' set 物料编码 ='+ char(39)+'B'+char(39)+' where 物料编码='+char(39)+'A'+char(39)
fetch next from c1 into @j
end
close c1
deallocate c1
exec (@i)
declare @i varchar(100)
declare @j varchar(20)
declare c1 cursor scroll for
select [name] from sysobjects where [id] in (select [id] from syscolumns where [name]='物料编码')
open c1
fetch first from c1 into @j
while @@fetch_status=0
begin
set @i= 'update '+@j+' set 物料编码 ='+ char(39)+'B'+char(39)+' where 物料编码='+char(39)+'A'+char(39)
fetch next from c1 into @j
end
close c1
deallocate c1
exec (@i)
set @i='select replace(物料编码,'+char(39)+'A'+char(39)+','+char(39)+'B'+char(39)+') from '+@j+ 'where 物料编码 like '+char(39)+'%A%'+char(39)
set @i='select replace(物料编码,'+char(39)+'A'+char(39)+','+char(39)+'B'+char(39)+') from '+@j