Use stored procedure Query and page 10 per page to display the book Loan Records

CREATE PROCEDURE Sp_pageing_abc @cur_page_numint,  --Current Page @page_sizeint--when the page size is passed, fill in the asbeginSelectTop @page_size * fromABCwhereId<= (SelectIsNull (min (id),0) from      (        SelectTop (@page_size * (1-1)) ID fromABCwhereis_borrow=1ORDER BY id DESC) asT) and is_borrow=1ORDER BY id DESC end---Note: If you do not want to add a condition that has been borrowed, the condition of the WHERE clause is removed, but the order by id Desc is preserved. Otherwise the correct result cannot be obtained.

Use stored Procedure query and page 10 per page to display book lending records