How does TOP work? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How does TOP work?

Message

18/11/2008 16:32:28

William Benavente
JZANUS
New York City, New York, États-Unis

18/11/2008 16:31:23

Craig Berntson
Quicken Loans
Salt Lake City, Utah, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: How does TOP work?

Versions des environnements

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

Visual FoxPro

Divers

Thread ID:

01362672

Message ID:

01362674

Vues:

>Yes, then it throws away what doesn't meet the criteria
>
>>Hello,
>>
>>If I want to select N top records, does VFP still create a whole resultset in memory?
>>
>>Thanks.

Is there any way to not select everything? How does it work in SQL Server ?

Répondre

Fil

Voir

Click here to load this message in the networking platform