SET ROWCOUNT#
Causes engine to stop processing the query after the specified number of rows are returned.
Syntax#
SET ROWCOUNT { number | @number_var }
Arguments#
number | @number_var
Is the number, an integer, of rows to be processed before stopping the specific query.
Remarks#
Argument values are ignored and do not change the default behavior.
Permissions#
Requires membership in the public role.