Platform System (PDW)

SET ROWCOUNT stops processing after the specified number of rows. In the following

example, note that more than 20 rows meet the criteria of. However,

after applying SET ROWCOUNT, you can see that not all rows were returned.

To return all rows, set ROWCOUNT to 0.

SET Statements (Transact-SQL)

See Also

AccountType = 'Assets'

-- Uses AdventureWorks
SET
ROWCOUNT 5;
SELECT
*
FROM
[dbo].[DimAccount]
WHERE
AccountType =
'Assets'
;
-- Uses AdventureWorks
SET
ROWCOUNT 0;
SELECT
*
FROM
[dbo].[DimAccount]
WHERE
AccountType =
'Assets'
;