Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to use select top with SQL Server 2000
Message
 
À
28/05/2008 16:37:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01320099
Message ID:
01320105
Vues:
15
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform