Maximum size of sql query text

Asked

Viewed 640 times

3

What is the maximum size of an sql query string? (Maximum query statement) Ex:

SELECT * FROM ajuda WHERE (id = 1 OR id = 2 OR id = 3 OR...

@Edit:

The bank I was using (access) has other limits besides those under the siege by @Paulohdsouza.

  • Number of characters in an SQL statement
  • Number of AND Operators in a WHERE or HAVING clause
  • Number of characters for a Parameter in a Parameter query
sql string query

  • Maximum size of the command?

  • I believe that there is no limit to the command but as you are using OR when the query finds one that returns true he stops executing.

  • has tried WHERE id in(1,2,3,4,5) ????

  • Oh I don’t know exactly what you want, but it would be nice if you edited the question and tried to be a little clearer.

  • The @Paulohdsouza answered what I wanted. I was not clear because I wanted to know the general database anyway. In English the question would make more sense since I can’t think of a translation for: Maximum query statement.

  • The maximum size will depend on your processor for the query. Because SQL is unlimited.

Show 1 more comment

1 answer

1

  • Well, I wasn’t clear about the database specifications and connection driver. But this wasn’t the point. Your answer is what I really wanted to know.

Browser other questions tagged sql string query

You are not signed in. Login or sign up in order to post.