delete_book.sql

图书馆系统建立

create procedure delete_book
(@book_id int)
as 
if @book_id is  null
begin
print '输入图书编号'
return -20
end
delete from book_info where book_id=@book_id
RETURN 0