book_delete.sql

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

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