Question

sql server 2008 R2 存储过程变量赋值问题

sql server 2008 R2 存储过程变量varchar(max)赋值也最多只有8000字符，这是什么原因导致？

Answer 1

官方文档这样写的：
varchar [ ( n | max ) ] Variable-length, non-Unicode character data. n can be a value from 1 through 8,000. max indicates that the maximum storage size is 2^31-1 bytes. The storage size is the actual length of data entered + 2 bytes. The data entered can be 0 characters in length. The ISO synonyms for varchar are char varying or character varying.
字段如果存储字符串的话，最多就8000个，max可以存储clob类型的大字段。