ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead. ntext、text、image类型将被抛弃了
哪看来的2G? SQLServer哪有什么2G?给个地址,还是你自己猜的 nvarchar [ ( n | max ) ] Variable-length Unicode string data. n defines the string length and can be a value from 1 through 4,000. max indicates that the maximum storage size is 2^31-1 bytes (2 GB). The storage size, in bytes, is two times the actual length of data entered + 2 bytes. 字符长度: 2^31-1,存储字节数:字符数*2+2
有些字符串函数不会自动把超定义长度的字符串转为max的
哪看来的2G? SQLServer哪有什么2G?给个地址,还是你自己猜的
ntext、text、image类型将被抛弃了
哪看来的2G? SQLServer哪有什么2G?给个地址,还是你自己猜的
msdn、sql文档里有啊
哪看来的2G? SQLServer哪有什么2G?给个地址,还是你自己猜的
nvarchar [ ( n | max ) ]
Variable-length Unicode string data. n defines the string length and can be a value from 1 through 4,000. max indicates that the maximum storage size is 2^31-1 bytes (2 GB). The storage size, in bytes, is two times the actual length of data entered + 2 bytes.
字符长度: 2^31-1,存储字节数:字符数*2+2