CODEWITHSUNDEEP
sql-server
svsLm
svsLm

Reputation: 127

Varchar(max) storage size in SQL Server 2012?

I want to create a table in which data type of one column is varchar(max).

How much can be the maximum size of the column?

Upvotes: 2

Views: 10268

Answers (1)

marc_s
marc_s

Reputation: 754993

A quick peek at the official SQL Server Books Online documentation would have showed you very easily:

varchar [ ( n | max ) ]
Variable-length, non-Unicode string data. n defines the string length and can be a value from 1 through 8,000. max indicates that the maximum storage size is 2^31-1 bytes (2 GB).

Upvotes: 4

Related Questions