Ms SQL parser data type varchar (max), nvarchar (max), varbinary (max)

In Ms sql2005 and later versions, the sequence data types (varchar (max), nvarchar (max), and varbinary (max) are added )). The Bytes data type can store up to 2 ^ 30-1 bytes of data.

These data types are behavior and small data types.Varchar,NvarcharAndVarbinarySame.

Microsoft uses this data type to replace the previous one.Text,NtextAndImageData type. The relationship between them is:

Varchar (max) ------- text;

Nvarchar (max) ----- ntext;

Varbinary (max) ---- image.

 

With the volume data type, it is more flexible to operate the volume data than before. For example, 'like' cannot be used in text before, and there is no such problem after varchar (max), because varchar (max) is in the same behavior as varchar (n, therefore, varcahr can be used on varchar (max.

In addition, this also supportsInsertedAndDeletedThe After trigger is used for reference of the values data type column in the table. Text won't work. In short, after using the timeline data type, I am "waist is not hurt, legs are not sour, and I can go to the sixth floor in one breath ". What are you waiting for? Use the volume type.