34,590
社区成员
发帖
与我相关
我的任务
分享
--未测试,请先备份数据库
exec sp_msforeachtable N'declare @s varchar(8000) select @s=isnull(@s,'''')+''update ? set ''+name+''=dbo.f_convert(''+name+'',0)'' from syscolumns where id=object_id(N''?'') print @s exec(@s)'
--try
declare @s varchar(8000)
select @s=isnull(@s,'')+'update 表 set '+name+'=dbo.f_convert('+name+',0)' from syscolumns where id=object_id('表')
print @s
exec(@s)
--try
declare @s varchar(8000)
select @s=isnull(@s,'')+'update 表 set '+name+'=dbo.f_convert('+name+',0)' from syscolumns where id=object_id('test')
print @s
exec(@s)
declare @sql nvarchar(max)
select @sql=isnull(@sql+';','')+'update 表 set '+name+'=dbo.f_convert('+name+',0)'
from syscolumns
where id=object_id('表')
--print @sql
exec(@sql)