关于SQL语句保留小数点的

select cast( 1231231.231231 as numeric(12,2))

 

 

SELECT  cast( CAST(500 AS DECIMAL(12,6))/10000 as numeric(12,12))