Published 20 November 2017
SET ROWCOUNT option is deprecated
SET ROWCOUNT option was replaced by the TOP(N) syntax of the SELECT statement.
SET ROWCOUNT sets the limit to the number of rows returned for the rest of the batch, whereas TOP(n) within the SELECT statement sets the number of rows to return by the query. The latter is much safer and easier to control.