The TOP clause in SQL Server 2005 has been enhanced. You can now specify an expression as the number definition in the TOP clause. This makes your TOP clause dynamic as you can pass the number value in a variable and use that variable in the TOP clause of your T-Sql query
DECLARE @TopVar AS int
SET @TopVar = 20
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|