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

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

 

posted on 2015-06-12 18:05  选择大于努力  阅读(5677)  评论(0编辑  收藏  举报

导航