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 zzyjy where 索書號=@ssh)
       begin
             set @flag=1
             select @jszh=借書證號,@isbn=ISBN,@jssj=借書日期 
                  from zzyjy
                    where 索書號=@ssh
             set @hssj=getdate()
             insert into zzyjyls
                  values(@jszh,@isbn,@ssh,@jssj,@hssj)
             delete from zzyjy
                  where 索書號=@ssh
        end
    else 
         set @flag=0