25 pts.
 SQL Server Command String
What is the max length of the Command String that can be submitted to SQL Server?

Software/Hardware used:
ASKED: December 21, 2007  3:40 PM
UPDATED: February 22, 2008  5:27 AM

Answer Wiki:
The max size of a SQL Batch query is 65536 bytes. If you are using dynamic SQL the max size of the command if 4000 characters as the data type must be NVARCHAR.
Last Wiki Answer Submitted:  February 22, 2008  5:27 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 64,520 pts.