22,301
社区成员




select 'alter table ['+object_name(a.[object_id])+'] alter column '
+a.name+' float '
from sys.columns a
inner join sys.systypes b
on a.system_type_id=b.xtype and b.name='int'
inner join sys.objects c
on a.[object_id]=c.[object_id] and c.[type]='U'
cast([字段名] as float)