Sql 中取小数点后面两位小数.
摘要:
selectconvert(numeric(8,2),round(UnTaxAmount,2))asUnTaxAmountfromView_SaleVoiceselectcast(UnTaxAmountasdecimal(20,2))asUnTaxAmountfromView_SaleVoice第一条感觉得好一些. 阅读全文
posted @ 2007-09-12 10:21 小土泥 阅读(1199) 评论(0) 推荐(0) 编辑