sqlserver 在SQL Server中批量修改有规律列的定义

declare@tnamenvarchar(255)=N'要修改的表名';

--修改所有以sl结尾的列名的小数位数为4位select syscolumns.name into #t1
from syscolumns,systypes 
where syscolumns.xusertype = systypes.xusertype 
and syscolumns.id =object_id(@tname)
and syscolumns.name like'%sl'and systypes.name='numeric';

whileexists(selecttop1 name from #t1)
begindeclare@cnamevarchar(255);
selecttop1@cname=name from #t1
delete #t1 where name=@cname;
declare@sqlnvarchar(1000);
set@sql=N'alter table '+@tname+' alter column '+@cname+' numeric(19,4)';
exec sp_executesql @sql;
enddroptable #t1;