xs_delete.sql

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

create procedure xs_delete
   @jszh char(8),@flag int output
as
   if exists(select* from xs
             where 借书证号=@jszh and 借书数=0)
      begin
           delete
              from xs
              where 借书证号=@jszh and 借书数=0
           set @flag = 0
      end
   else
set @flag= 1