How do I programmatically limit the number of rows in MS SQL?

9 years ago by pharmakon

I would like to be able to limit the number of rows using a variable. SELECT TOP only allows integer, so SELECT TOP @RowLimit is invalid.

Related tags: MSSQL

9 years ago by

You can do this by using the rowcount keyword as follows:

SET ROWCOUNT @RowLimit

After the query, set rowcount back to 0

SET ROWCOUNT 0

Rating:

2003

Similar Problems