复制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 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23. |
喜欢
讨厌