create procedure p_set
as
declare tb cursor for
SELECT sql='alter table ['+d.name
+'] alter column ['+a.name+'] '
+b.name+'(8,3)'
FROM syscolumns a left join systypes b on a.xtype=b.xusertype
inner join sysobjects d on a.id=d.id and d.xtype='U' and d.name<>'dtproperties'
where
b.name in('decimal')
order by d.name,a.name
declare @sql varchar(1000)
open tb
fetch next from tb into @sql
while @@fetch_status = 0
begin
print @sql
exec(@SQL)
fetch next from tb into @sql
end
close tb
deallocate tb
go
SQL SERVER 批量修改字段的数据类型
最新推荐文章于 2024-08-06 10:07:20 发布