This is more an SQL question than a SQL server question,
but this still seemed to be the best forum to ask.
I need to know the maximum length in characters of
raw SQL command strings in each of several relevant
Microsoft technologies, namely: VB6, Access 2000 and
DAO (last version). A guess at the answer for Access 2002,
ADO (latest version), ADO.net and even MySQL would
be helpful, too. The first three are the most important
to me (VB6, etc.).
Links to authoritative sources would be terrific.
In ADO, for instance, what I'm looking for would be
the maximum length of the Command.CommandText property.