declare @tablename varchar(50),@sql varchar(3000)
declare table1 cursor for
select object_name(a.id)as tablename from syscolumns a,
sysobjects b,
systypes c
where a.id=b.id
and a.xtype=c.xtype
and b.xtype='u'
and c.name in('varchar','nvarchar','char','nchar','text','ntext')and object_name(a.id)<>'t'
and a.name='gsbh' order by object_name(a.id)
open table1
fetch next from table1 into @tablename
while @@FETCH_STATUS = 0
begin
select @sql='update '+@tablename+' set gsbh=''117'' where gsbh=''118'''
exec(@sql)
fetch next from table1 into @tablename
end
close table1
deallocate table1
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。