title: How does SQL Server store more than 4000 characters in NVARCHAR(max)?
body: <p>I have defined a stored procedure that has a parameter of type <code>NVARCHAR(max)</code> and I process that string in my <code>stored procedure</code>. I know that max of <code>nvarchar</code> is 4000. But I have passed a string with 5700 characters to my sp with no errors. Is it possible?</p>