the TOP clause does not have a hardcoded maximum limit on the number of rows you can specify.

The actual limit is constrained by:

• Available system memory

• Query performance

• The total number of rows in the result set or source table

  If you specify a value larger than the number of available rows, SQL Server will simply return all available rows.