title: sql top N value
body: <p>How can I make a SQL query and have a parameter the top N value. For example the first person wants to see the top 10 values, the next perhaps the top 50, maybe the top 100. Would I say something like SELECT TOP =@Value from Table? </p>
  
  <p>Thanks</p>
  
  <p>Yes this is for SQL Server. Standard Query, showing everything, but id like to limit the number of rows returned based on input from the user. </p>