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
Sql 中取小数点后面两位小数
原文：http://www.cnblogs.com/rwh871212/p/4572298.html
