sql server 中 ‘cast’和‘decimal’的用法

declare @dec decimal(28,2)
declare @num decimal(28,4)


select @dec=cast(1.0 as decimal(38,37))/3,@num=cast(1.0 as NUMERIC(38,37))
select @dec,@num,1.0/3,cast(1.0 as float(24))/3,1.00/3,cast(1.0 as float(3))/3 


declare @ec decimal(28,2)
select @ec=cast(1.0 as decimal(38,37))/3
select @ec


SELECT CAST('12.5' AS decimal(4,2))