SET ROWCOUNT (Transact-SQL) – SQL Server

The SQL ROWCOUNT is a SQL Server SET statement which causes SQL Server to stop processing the query after the specified number of rows are returned