问题描述
我正在创建一个关于图书馆管理系统的项目。
我想要计算目前图书馆目前可用的图书数量。
没有。书籍根据问题和回报而有所不同。
请向我提供STORED PROCEDURE和C＃代码，以便在Windows应用程序中调用sp。
我的数据库详细信息：
1.表库包含有关列的书籍的详细信息：
book_name，book_author，book_id，book_price，book_quantity，avail_book_qty。
2.表book_issue包含
book_id，stu_id，issue_date，return_date
变化没有。书籍必须存储在avail_book_qty。
I am creating a project on Library Management System.
I want to count the no of books currently available in currently in the library.
The no. of books vary according to its issue and return.
Kindly provide me the STORED PROCEDURE and the C# code to call the sp in the windows application.
My DB details:
1. Table library contains details regarding books with columns as:
book_name, book_author, book_id, book_price, book_quantity, avail_book_qty.
2. Table book_issue contains
book_id, stu_id, issue_date, return_date
The varying no. of books must get stored in avail_book_qty.
推荐答案
这篇关于编写存储过程来计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！