declare @num numeric(10,2)
set @num = 12.20
select @num
select cast(@num as numeric)
/*
------------
12.20(所影响的行数为 1 行)
--------------------
12(所影响的行数为 1 行)*/
set @num = 12.20
select @num
select cast(@num as numeric)
/*
------------
12.20(所影响的行数为 1 行)
--------------------
12(所影响的行数为 1 行)*/
select cast(@num as real)
set @num = 12.20
select @num
select cast(@num as real)/*
------------
12.20(1 row(s) affected)
------------------------
12.2(1 row(s) affected)
*/