You could do something like this...

Set Rowcount @rowlimit  

select col1, col2 from myTable where...