Tutorial :Pagination in for searching



Question:

table 'sample' contaning fields [AffiliateId] as a primary key, [AffiliateCode] L, [Name] , [AddressId] [, [Url] , [EmailId] , [ShopId] ,

i need a stored procedure for custom paging


Solution:1

in sqlserver 2005 reference or example:

SELECT * FROM ( SELECT row_number() OVER (ORDER BY id) AS resultNum, id FROM table_name) AS numberResultsWHERE resultNum  BETWEEN ? AND ?  

for older versions see reference or reference2


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »