SQL Server Command String
Home > IT Answers > SQL Server > SQL Server Command String
Hank1039
25 pts.
0
Q:
SQL Server Command String
SQL Server security
What is the max length of the Command String that can be submitted to SQL Server?
ASKED: Dec 21 2007  3:40 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Feb 22 2008  5:27 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46795 pts.  |   Feb 22 2008  5:27AM GMT

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

 
0