Use Select Top @N
-
Hello evebody,
I have a new question for you.
Somebody knows how to use the sentence:
Select Top 10 * from AnyTable
Using instead 10 a variable value like:
Select Top @Count * from AnyTable
Without use Dynamic SQL or something like
exec ('select top @count * from AnyTable) or like
execsql ('select top @count * from AnyTable) or like
Thank you Fellows
-
Check out set rowcount in books online.
-
Thank you RGR'us for all your help.
You know you help a Lot.
-
HTH.
-
One of the features of SQL 2K5 is to be able to use the above SELECT TOP @N FROM ... type syntax
Good Hunting!AJ Ahrens
webmaster@kritter.net
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply