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
select cast (UnTaxAmount as decimal ( 20 , 2 )) as UnTaxAmount from View_SaleVoice
第一条感觉得好一些.