22,210
社区成员
发帖
与我相关
我的任务
分享
declare @num float
set @num=83.09
select @num*40
select 83.09*40
select cast(83.09*40 as float)
select cast(83.09*40 as decimal(18,2))
/*
----------------------
3323.6
(1 row(s) affected)
---------------------------------------
3323.60
(1 row(s) affected)
----------------------
3323.6
(1 row(s) affected)
---------------------------------------
3323.60
(1 row(s) affected)
*/