Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BETWEEN or BETWEEN?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00132234
Message ID:
00132260
Vues:
13
>Hi all,
>
>There are two ways to write "BETWEEN" clauses in a SQL query or view:
>... WHERE dDate BETWEEN ?vp_dBeg AND ?vp_dEnd
>or
>... WHERE BETWEEN( dDate, ?vp_dBeg, ?vp_dEnd)
>
>Is there a performance difference between the two, or is it only a matter of writing style?
>
>José

Hi Jose,

I believe that the former is standard SQL syntax. This may be an issue if there's ever any intention to upsizing the data source.
George

Ubi caritas et amor, deus ibi est
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform