xs_delete.sql

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

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