Max length of SQL statement, is there one?

[Bob Dufour]

Is there a max length for a select, insert or update statement? If so what
would it be?

Thanks,

Bob

 

[Miha Markic [MVP C#]]

Hi Bob,

If there is one then it is database dependent.

 

[Bernie Yaeger]

Hi Bob,

128 megs (sql server 2000).

HTH,

Bernie Yaeger

 

[Miha Markic [MVP C#]]

Huh, a serius limitation :-D

 

[Bob Dufour]

Thanks to all,

Bob