替换所有与该字段值,相关的表

王朝other·作者佚名  2006-11-24
窄屏简体版  字體: |||超大  

declare @oldstr varchar(100)

set @oldstr='原字符串' --原字符

declare @newstr varchar(100)

set @newstr='新字符串' --新字符

declare @s varchar(8000)

declare tb cursor local for

select s='if exists(select 1 from ['+b.name+'] where ['+a.name+'] like ''%'+@oldstr+'%'')

update ['+b.name+'] set ['+a.name+']='''+@newstr+''' where ['+a.name+']='''+@oldstr+''' '

from syscolumns a join sysobjects b on a.id=b.id

where b.xtype='U' and a.status>=0

and a.xusertype in(175,239,231,167)

open tb

fetch next from tb into @s

while @@fetch_status=0

begin

exec(@s)

fetch next from tb into @s

end

close tb

deallocate tb

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航