-----取小数点后两位declare @i1 int ,@i2 int set @i1 = 11 set @i2 =2select str(cast(@i1 as numeric(9,2))/cast(@i2 as numeric(9,2)),10,2)
-----如何在一个SQL句中实现:两整数相除如何取小数点后两位?如何防止除零错?declare @i1 int ,@i2 int set @i1 = 11 set @i2 =2 if @i2<>0 select cast(@i1/(@i2+0.0) as decimal(9,2)) else select '除数不能为0'
declare @i1 int ,@i2 int set @i1 = 11 set @i2 =2 if @i2<>0 select cast(@i1/(@i2+0.0) as decimal(9,2)) else select '除数不能为0' 对,我就是这样做的
set @i1 = 11
set @i2 =2select str(cast(@i1 as numeric(9,2))/cast(@i2 as numeric(9,2)),10,2)
set @i1 = 11
set @i2 =2
if @i2<>0
select cast(@i1/(@i2+0.0) as decimal(9,2))
else
select '除数不能为0'
set @i1 = 11
set @i2 =2
if @i2<>0
select cast(@i1/(@i2+0.0) as decimal(9,2))
else
select '除数不能为0'
对,我就是这样做的