Home Forums SQL Server 2005 Development Difference between varchar(max) and varchar(8000) RE: Difference between varchar(max) and varchar(8000)
praveshsinghfaq
SSC Enthusiast
Points: 134
More actions
May 7, 2013 at 3:21 am
#1612895
Difference between Varchar(8000) and Varchar(MAX)
Varchar(8000) stores a maximum of 8000 characters, and
Varchar(MAX) stores a maximum of 2,147,483,647 characters
It supported in SQL Server 2005 or above version