sql server 2005 金额函数

CREATE FUNCTION matrixing(@amount AS money, @type as INT)
RETURNS money
AS
BEGIN
if @type = 1
begin 
select @amount=round(@amount,1,0) ---分四舍五入
end
else if @type = 2
begin
select @amount=round(@amount,1,-1) ---分全舍
end
else if @type = 3
begin
select @amount=CEILING(10*@amount)/10  --- 逢分进角
end
else if @type = 4
begin
select @amount=round(@amount,0)   ---角四舍五入
end
else if @type = 5
begin
select @amount=round(@amount,0,1) ---角全舍
end
else if @type = 6
begin
select @amount=CEILING(@amount)  --- 逢角进元
end
 RETURN isnull(@amount,0);
end