jy_delete.sql

来自「本人自己编写的!!!!!看看这样做的怎么样」· SQL 代码 · 共 19 行

create procedure jy_delete
  @ssh char(10),@flag int output
as
   declare @jszh char(8),@isbn char(16)
   declare @jssj datetime,@hssj datetime
  if exists(select* from jy
             where 索书号=@ssh)
      begin
          set @flag=1
          select @jszh=借书证号,@isbn=isbn,@jssj=借书时间 from jy 
              where 索书号=@ssh
          set @hssj=getdate()
          insert into jyls
             values (@jszh,@isbn,@ssh,@jssj,@hssj)
           delete from jy
              where 索书号=@ssh
       end
   else
set @flag= 0