於小位理的。
- SQL code
select Cast(3.88 As Decimal(10,2))*Cast(83.87 As Decimal(10,2)), Cast(Cast(3.88 As Decimal(10,2))*Cast(83.87 As Decimal(10,2)) As Decimal(10,2)), Cast(3.88 As Decimal(10,2))*Cast(27.9 As Decimal(10,2))*2, Cast(Cast(3.88 As Decimal(10,2))*Cast(27.9 As Decimal(10,2))*2 As Decimal(10,2))--325.4156 325.42 216.5040 216.50
上面是在查分析器面的,有。
但是我在面:
Cast(Cast(3.88 As Decimal(10,2))*Cast(83.87 As Decimal(10,2)) As Decimal(10,2))
果325.4
Cast(Cast(3.88 As Decimal(10,2))*Cast(27.9 As Decimal(10,2))*2 As Decimal(10,2))
果216.5
1、保留的2位小什麽只有1位了?
但是字段其它地方又有2位小的地方,如
3.88*159.85=620.218示620.22
3.88*42.98*2=333.5248示333.55(是不是有?是333.52啊)
小位好像一直有差,要麽多,要麽少。量大了,差可就大了。
2、怎麽才能表或者字段面示的都是保留2位小,而不是有的一位有的位。
[解决办法]
看看你的视图。。