Is there a way to do a SELECT TOP # using a variable for the #?
In other words I'm doing a SELECT TOP 50* FROM DATATABLE
If I pass an @.value for the number
SELECT TOP @.value* FROM DATATABLE doesn't work
I am generating a random sampling of data and I want to allow the user to select the number of results they choose to have.
Thanks in advance.
I believe that is possible in 2005 and not in 2000. You can however use SET ROWCOUNT in 2000.
DECLARE @.tintSET @.t = 10SET ROWCOUNT @.tSELECT *FROM YourTableSET ROWCOUNT 0|||
In 2005, the following works:
DECLARE @.t int
SET @.t = 20
SELECT TOP(@.t) * FROM yourTable
No comments:
Post a Comment