Menu
What is the maximum length of an SQL statement in SQL Server? Does this length depend on the version of SQL Server?
For example, in
DECLARE @SQLStatement NVARCHAR(MAX) = N'Something'
EXEC(@SQLStatement)
the @SQLStatement is allowed to be X characters long. What is X?
406
The maximum standard SQL query length is 1024.00K characters, including comments.
You still Cannot have a Single Unbroken Literal String Larger than 8000 (or 4000 for nVarChar). Literal Strings are those you hard-code and wrap in apostrophe's. You must Break those Strings up or SQL Server will Truncate each one BEFORE concatenating. I add ' + ' every 20 lines (or so) to make sure I do not go over.
varchar [ ( n | max ) ] Variable-size string data. Use n to define the string size in bytes and can be a value from 1 through 8,000 or use max to indicate a column constraint size up to a maximum storage of 2^31-1 bytes (2 GB).
SQL Server allows a maximum of 32,767 user connections.
It's going to be 65,536 times your network packet size, according to the documentation
Seems like this is the same at least since SQL Server 2005
76
Verbatim from the documentation:
65,536 * Network Packet Size
What isn't clear, but which any sane person would immediately question, is what does "Network Packet Size" mean?
Network packet size, in this case, as expected, does not refer to physical size, since this would break the abstraction of end-to-end guaranteed delivery streaming protocol (TCP), but rather refers to packet size in the context of the Tabular Data Stream protocol used by SQL Server for communication. According to the same documentation, the default size of a TDS packet is 4KB.
31
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
