What is the max number of items in IN clause? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

What is the max number of items in IN clause?

Message

De

27/04/2010 10:21:03

Kevin Goff
Pennsylvanie, États-Unis

À

27/04/2010 09:05:35

Naomi Nosonovsky
Wisconsin, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

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

Titre:

Re: What is the max number of items in IN clause?

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Vista

Network:

Windows 2003 Server

Database:

MS SQL Server

Divers

Thread ID:

01462166

Message ID:

01462186

Vues:

68

Naomi, I question the judgment of this for anything more than a few items. Joining against a temp table/table variable/subquery/etc is the way to go.

"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313

Click here to load this message in the networking platform