SELECT @type=t.name, @prec=c.prec FROM sysobjects o
JOIN syscolumns c on o.id=c.id
JOIN systypes t on c.xusertype=t.xusertype WHERE o.name = @SortTable AND c.name = @SortName
获取SQL中某一列的类型及精度,布布扣,bubuko.com
原文：http://www.cnblogs.com/sjm19910902/p/3785742.html