jy_delete.sql

来自「有读者和图书信息的添加查询,借还书等,先建立数据库和ODBC数据源」· SQL 代码 · 共 18 行

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