scheduletransfer.txt

来自「java voice chat based on java core ,, u 」· 文本 代码 · 共 18 行

create procedure  scheduletransfer(@acno varchar(10), @payee varchar(10), @tranpwd varchar(10), @amt money,@schddate datetime, @tdesc  varchar(50))
as
  declare  @id  integer

   if not exists ( select  * from users where acno = @acno  and tpwd = @tranpwd )
   begin
      raiserror('Invalid Transaction Password',16,1)
        return
     end 

     select @id = isnull(max(stid),0) + 1 from schdtrans

      insert into schdtrans 
        values(@id, @acno,@payee,@schddate,@amt,@tdesc)