declare @int2 int;
declare @int3 int;
declare @dec2 decimal(10,9);
declare @dec3 decimal(10,9);
set
@int2 = 2
, @int3 = 3
, @dec2 = 2
, @dec3 = 3;
insert into foo( id )
select "int/int div", @int2 / @int3 union
select "int/dec div", @int2 / @dec3 union
select "dec/int div", @dec2 / @int3 union
select "dec/dec div", @dec2 / @dec3;
go
select * from foo;