Retrieve a fixed number of rows from sorted output
When using forms to show results from SQL Server databases, you often encounter the problem of trying to fit a fixed number of sorted rows into a form designed with a fixed size. In SQL Server 2008 R2 and earlier, you have to execute queries that retrieve all the data, then use different search features to locate the rows of data you want to display in the form. In SQL Server 2012, there are two new arguments in the SELECT statement's ORDER BY clause that let you retrieve a fixed ...
Buy This Project Plan Now!
This content is part of the Migrating to SQL Server 2012 Project Plan.
Purchase this Project Plan to receive:
- Step-by-step guidance for managing your project, start to finish
- Tested advice for preparing for and completing your project
- Insights to help you avoid common pitfalls and traps
Already registered? Log In here