Home > IT Answers > SQL Server > SQL Server Command String
Hank1039
25 pts.
 SQL Server Command String
SQL Server security
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
RELATED QUESTIONS
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.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Denny Cherry
 64,520 pts.