Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use select top with SQL Server 2000
Message
 
To
28/05/2008 16:37:16
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01320099
Message ID:
01320105
Views:
13
>sqlserver 2000 that i use doesn't recognize the TOP clauseof the select 200 * from ...
>
>in the help file of sqlserver, it said that TOP is a reserved word and it must not be used.
>
>is there a another way to select the n top records ?

NO WAY!!!
In SQL Server 2000 you can't use VARIABLE in TOP clause but you still could use SELECT TOP 200.
And TOP is reserved word but it is reserved word just for that case.
And it must be not use to name fields, tables, datasbases, variables :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform