Established ROWCOUNT selection boundaries the quantity of rows that return from a query. When we set SET ROWCOUNT as 4 for the following question, it procedures The full query but only returns 4 rows. Established ROWCOUNT alternative overrides the TOP search phrase, If your set price of the ROWCO