Maximum query text size sql

3

What is the maximum length 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 limits other than those set 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 query parameter
asked by anonymous 02.12.2015 / 15:51

1 answer

1

Hello,

The value in KB is

65,536 * Network Packet Size

Network Packet Size you configure on your SQL server

Source: link

    
02.12.2015 / 16:37