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.