TSQL - Dynamic Top N

Declare @rows int;

set @rows = 5;

select top (@rows)

      *

from

      TABLE_NAME_HERE

;