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 from the query. The latter is much safer and easier to control.

Didn't find what you were looking for?