Why we use SET ROWCOUNT in Sql

This syntax is used in SQL Server to stop processing the query after the specified number of rows are returned.