In SQL Server, smaller data can be stored using varchar (n), nvarchar (n), and varbinary (n) types, storing large data, using varchar (max), nvarchar (max), and varbinary (max ) Instead of the text, ntext, and image data types.
which
varchar (max) instead of text;
nvarchar (max) instead of ntext;
varbinary (max) instead of image
The difference between ntext and nvarchar (MAX)
NTEXT
By default, ntext stores text data in the LOB structure, only pointers are stored in the table structure, and the pointer points to where the data is stored in the LOB.
NVARCHAR (MAX)
By default, no more than 8,000 bytes of data is stored directly in the table structure, and the data is stored in the LOB structure just like ntext.
Reference: nvarchar (max) http://www.studyofnet.com/news/902.html
This article is from the "Learning also leisure" blog, please be sure to keep this source http://studyofnet.blog.51cto.com/8142094/1692423
nvarchar (max) in SQL Server