Sql 中取小数点后面两位小数

时间：2015-06-12 18:58:48 收藏：0 阅读：603

select convert(numeric(8,2),round(UnTaxAmount,2))as UnTaxAmount from View_SaleVoice

select   cast(UnTaxAmount as decimal(20,2)) as UnTaxAmount   from View_SaleVoice

原文：http://www.cnblogs.com/rwh871212/p/4572298.html