34,837
社区成员




select cast(50/50 as decimal(10,2))
select cast(50/50 as decimal(10))
select cast(cast(50*1.0/50 *100 as decimal(10,2)) as varchar(10))+'%'
select 30/50, 30*1.0/50
/*
----------- ---------------------------------------
0 0.600000
(1 row(s) affected)
*/
select cast(50*1.0/50 as decimal(18,2)),cast(30*1.0/50 as decimal(18,2))
/*
--------------------------------------- ---------------------------------------
1.00 0.60
(1 行受影响)
*/
select 30/50, 30*0.1/50
/*
----------- ---------------------------------------
0 0.060000
(1 row(s) affected)
*/