requestforchequebook.txt

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

create procedure  RequestForChequeBook(@acno varchar(10))
as
if  exists ( select  * from requests where acno = @acno and request = 'c') 
   raiserror ('A request for cheque books is pending!',16,1)   
else
    insert into requests values (@acno,'c',null,getdate())