create proc zz
@fromid int,
@toid int,
@moneys money,
as
begin tran
update jine set moneys = moneys-@moneys where @fromid = id
update jine set moneys=moneys+@moneys where @toid=id
if @@error<>0
begin rollback tran
return 0;
end
else
begin commit tran
return 1
end
------------------------------------------------------------------------
在关键字 'as' 附近有语法错误。