nvarchar(n) and nvarchar(max) different datatypes?

Hi Mordechai,

Although I didn't find any documentation for it , but if you check it practically , then you will find bydefaul when you define any column as nvarchar(max) , its size would be set to -1 , which is less then the size of any nvarchra(value) columns length. Regarding difference in data type , so there is no difference in between nvarchar(value) and n varchar(max).

http://msdn.microsoft.com/en-us/library/ms186939.aspx

Here is a sample