title: SQL Server Nvarchar(max)
body: <p>I have an insert statement that one of the columns i have the column type nvarchar(max) desc. I have noticed that when I looked at some of the records in my database that desc column was sometimes blank. Being that there is validation through my GUI, I knew that was impossible. After further testing I found out that if the text for that column is to large, it just wont insert that data. I found this kind of odd b/c I thought it would give me some sort of error or not insert the record entirely, but it justs leaves that column blank. Is there a limit to the nvarchar(max) and if there is is there some other datatype i can use in its place. I did a test a the charcters I tried to insert is over 20,000 but it varies on end user inputs.</p>
  
  <p>'<strong><em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>*</strong><em>EDITS</em><strong><em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>***</strong></p>
  
  <p>Thanks everyone for you quick reply, through research I found that you guys are correct and it will hold (holding) that much information. What I found out is that when using Microsoft Management Studio if the size of the column your quering has to many characters when your results come back it appears blank. To verify this what I did was use the len(COLUMN_NAME) function and saw that the character length is what I expected. Does anyone know a way I can change the setings in Microsoft Management Studio to ACTUALLY see the results?</p>