How to limit rows in select using parameter

Question

I would like to set limit for selected rows using parameter but obviously I can't write something like:

select top @count * from tbl

Also, I'm not very happy about turning select into string like:

exec('select top ' + casttovarchar(@count) + ' * from tbl')

Question: Is it posible and how to parametrize select top?

Answer 1

It is possible using brackets:

select top (@count) * from tbl