TOP 100 PERCENT balking - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

TOP 100 PERCENT balking

Message

28/02/2006 17:32:16

Sergey Berezniker
New York, États-Unis

28/02/2006 16:33:01

Cheryl Qualset
Qualset Computer Consulting
Davis, Californie, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Import/Export

Titre:

Re: TOP 100 PERCENT balking

Versions des environnements

SQL Server:

SQL Server 2000

Divers

Thread ID:

01100064

Message ID:

01100180

Vues:

>The current compatibility level is 65.
>
>Are we on to something here? Should it be set to 80?

Yes if you want to use all new features introduced after SQL 6.5. Otherwise they will be disabled and TOP clause is one of them.

--sb--

Répondre

Fil

Voir

Click here to load this message in the networking platform