把sql存储过程变成自定义函数
create procedure pro_savemoney
@cn varchar(15),
@money decimal(18,2)
as
begin
update cardinfo
set balance= balance + @money
where cardnumber = @cn
insert into transinfo(cardnumber,transtype,transmoney)values(@cn,'存入',@money)
end