total_lend_book.sql

图书馆系统建立

CREATE PROCEDURE Total_Lend_Book
(@stu_id int)
AS
SELECT count(book_id)
FROM lend_book
WHERE stu_id=@stu_id
RETURN 0