varchar(max) and varbinary(max) Questions and Answers
The following applies to SQL Server 2008. How big of an allocation does max represent in the case of varchar(max) and varbinary(max)? Up to 2 ^ 31 – 1 bytes or just about 2gb. Can I specify a varchar(9000) or varbinary(12000)? No. If you are going to specify an actual number instead of (max) then your limit is 8000. …
varchar(max) and varbinary(max) Questions and Answers Read more »