select top 10 records without using TOP n clause

'SET ROWCOUNT ' option causes SQL Server to stop processing the query after the specified number of rows are returned.
SET ROWCOUNT overrides the SELECT statement TOP keyword if the rowcount is the smaller value.


-- Without using TOP n clause
SET ROWCOUNT 10
SELECT * FROM CITY ORDER BY CITY_NAME
SET ROWCOUNT 0