今天用sqlserv2000的round函数,发现结果与自己需要的不一致,请教各位:语句如下:
select area ,round(area,2) as r_area from dl结果如下:
area r_area
3149.7206439991314 3149.7199999999998
240998.68298048322 240998.67999999999
43.765739500211581 43.770000000000003
682.00451950028685 682.0area 字段的数据类型为:float(8)
select area ,round(area,2) as r_area from dl结果如下:
area r_area
3149.7206439991314 3149.7199999999998
240998.68298048322 240998.67999999999
43.765739500211581 43.770000000000003
682.00451950028685 682.0area 字段的数据类型为:float(8)
declare @area float(8)
set @area = 3149.7206439991314
select @area
,round(@area,2)
--3149.721 3149.72
select area ,cast(round(area,2) as numeric(18,2)) as r_area from dl