Advertisement
A. With SQL 6.5 and below use the "set rowcount <n>" option.
This option is still available with SQL 7.0, but this supports the TOP() function as well which will optimise better so use this instead. "select TOP(n) from .........."
Advertisement
How can I restrict the number of rows returned to my query in SQL Server?
IT/Dev Connections
Las Vegas
September 30th - October 4th
You'll have the opportunity to experience:
• The Microsoft
Technology Roadmap
• Office 365 Implementation
• Hyper-V Optimizing
• Windows 8 Deployment
and much more!
Come See Paul Thurrott & Rod Trent in Person!
Advertisement
Upcoming Training
During over 6 hours of training you can join John Savill from your computer as he will walk you through the key components and capabilities of System Center 2012, what’s involved in using the components, and the benefit they can bring to your environment.
Current Issue
May 2013 - The NameTranslate object is useful when you need to translate Active Directory object names between different formats, but it's awkward to use from PowerShell. Here's a PowerShell script that eliminates the awkwardness.
Windows Forums
Get answers to questions, share tips, and engage with the Windows Community in our Forums.
Featured Products
Advertisement
Advertisement