Use the @@rowcount global variable to help develop appropriate limits for row count. Selecting this variable after running a typical query can tell you how many rows the query returned.
View this book as PDF
