--我的也是money型的,但我的数据有4位小数啊. mprice --------------------- 234.0000 23432.0000 456.0000 234.0000 456.0000 select top 5 mprice from tgoods order by id desc------------------------------ mprice --------------------- 234.0000 23432.0000 456.0000 234.0000 456.0000 ------------------------------ select top 5 convert(decimal(8,2),mprice) from tgoods order by id desc ------------------------------ ---------- 234.00 23432.00 456.00 234.00 456.00 ------------------------------
mprice
---------------------
234.0000
23432.0000
456.0000
234.0000
456.0000
select top 5 mprice from tgoods order by id desc------------------------------
mprice
---------------------
234.0000
23432.0000
456.0000
234.0000
456.0000
------------------------------
select top 5 convert(decimal(8,2),mprice) from tgoods order by id desc
------------------------------
----------
234.00
23432.00
456.00
234.00
456.00
------------------------------