编写存储过程来计数 [英] To write a stored procedure to count

问题描述

我正在创建一个关于图书馆管理系统的项目。



我想要计算目前图书馆目前可用的图书数量。

没有。书籍根据问题和回报而有所不同。

请向我提供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.

推荐答案

请提供STORED PROCEDURE和C＃代码，以便在Windows应用程序中调用sp。

不会。这里的效果不一样。



以下是询问者的预期：

1. 首先尝试你想做什么！你可能会发现它并不那么难。

2.制定你所做的事情看似问题/不工作。



尝试一下，告诉你是否面临问题。

各位会员非常乐意为此提供帮助。

Kindly provide me the STORED PROCEDURE and the C# code to call the sp in the windows application.
No. It does not work like this here.

Here is what is expected of enquirers:
1. TRY first what you want to do! You may find that it''s not that hard.
2. Formulate what was done by you that looks like an issue/not working.

Try them and tell if you face issues.
Members will be more than happy to help like this.

这篇关于编写存储过程来计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！