Code Analysis

DEP014

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.

Available in

SQL Prompt

SQL Code Guard



Didn't find what you were looking for?