Record a commonly used paging Stored Procedure

Code
1 Set Ansi_nulls on
2 Set Quoted_identifier on
3 Go
4 -- Obtain a category by category ID
5
6
7
8 Create procedure p_getlistbytypeid
9 (@ Startindex Int ,
10 @ Endindex Int ,
11 @ Product_type Int
12 )
13 As
14 Set Nocount on
15 Declare @ indextable table (ID Int Identity ( 1 , 1 ), NID Int )
16 Set Rowcount @ endindex
17 Insert into @ indextable (NID) Select product_id from product Where Product_type = @ Product_type order by product_id DESC
18
19 Select * From product
20 Inner join @ indextable t on A. product_id = T. Nid
21 Where Product_type = @ Product_type and T. ID between @ startindex and @ endindex order by T. ID
22
23 Set Nocount off
24 Return
25
26
27
28
29
30
31
32
33