What is the maximum length of a SQL statement? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

What is the maximum length of a SQL statement?

Message

De

22/07/2003 00:20:22

Lynda Taylor
Bellevue, Washington, États-Unis

À

21/07/2003 18:07:14

Fred Lauckner
Houston, Texas, É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 maximum length of a SQL statement?

Divers

Thread ID:

00812168

Message ID:

00812219

Vues:

14

I don't use Oracle but I seem to remember that the statement length is 8192 characters for SQL server. If you are passing the statement to SQL Server using variables, each variable is limited to just 255 characters so it's usually necessary to string several together.

Click here to load this message in the networking platform