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.

See Also