{infiniteZest}
// Articles. Tutorials. Utilities.
Home  |   Search  |   Login  
Categories Skip Navigation Links
New / All
AJAX
Apple
ASP.NET
.NET
Git
Google / Android
Python / IronPython
Miscellaneous
SQL Server
Article Listing
Sort By:
Selecting the top x records from a query using one order by clause and then ordering the records with in that set of records becomes easy with the WITH keyword in SQL Server 2005. This article looks at creating a temporary table and then querying on that table.
SQL Server 2005 provides a way to obtain a range of records obtained from a SELECT statement using row_number. This article has a stored procedure that gives the records of a given pagesize from given pagenumber.
Page 1 : Article 1 to 2 of 2
About  Contact  Privacy Policy  Site Map