Related Information
For information on creating and dropping the error table, see SQL Data Definition Language.
As an option to the SELECT statement, the TOP N option automatically restricts the output of queries to a certain number of rows. This option provides a fast way to get a small sample of the data from a table without having to scan the entire table. For example, a user may want to examine the data in an Orders table by browsing through only 10 rows from that table.
The value of N can be passed into the operator by means of a macro, stored procedure, or USING request modifier parameter.