How could you select top N records in Ms SQL Server?

SELECT TOP N * FROM <TableName>

Or

SELECT TOP N PERCENT <Column_01>, <Column_02>
FROM <TableName>
WHERE <Condition>

Or

( For SQL Server 7.0 or earlier )
SET ROWCOUNT N
SELECT <Column_01>, <Column_02>, <Column_03>
FROM <TableName>
ORDER BY <Column_Name> DESC