delete_book.sql

来自「图书馆系统建立」· SQL 代码 · 共 10 行

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