declare @a decimal(18,2)
declare @b decimal(18,2)
declare @c decimal(18,2)
set @a = 10
set @b = 1set @c =@a/@b
select @a/@b
select @c
----------------------------------------
10.00000000000000000000(所影响的行数为 1 行)
--------------------
10.00(所影响的行数为 1 行)
declare @b decimal(18,2)
declare @c decimal(18,2)
set @a = 10
set @b = 1set @c =@a/@b
select @a/@b
select @c
----------------------------------------
10.00000000000000000000(所影响的行数为 1 行)
--------------------
10.00(所影响的行数为 1 行)
------------Sample--------------------
declare @D1 decimal(18,2),
@D2 decimal(18,2)set @D1='20.62'
set @D2='2.26'select round(@D1/@D2,2)
select convert(decimal(18,2),round(@D1/@D2,2))----The results:
9.12000000000000000000
9.12