book_delete.sql

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

create procedure  book_delete 
    @isbn char(16),@flag int output
as
  if exists(select* 
             from zzybook
               where ISBN=@isbn and 复本量=库存量)
               begin 
                  delete
                  from zzybook
                    where ISBN=@isbn
                    set @flag=0
              
               end
  else
      set @flag=1