Code Snippet - SQL Paging Stored Procedure - CodeWrapper.com

added by codewrapper
3/7/2010 4:21:42 AM

71 Views

This sp is useful where paging is required on huge tables. It selects the exact data instead of getting whole table data. It works on one table, so that if you have to select from multiple tables, then you can create a view and pass it's name to this sp as @table parameter.


0 comments