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

Hi!

You can get the help from the following link. I hope it very helpful for you.

http://www.mindstick.com/Blog/479/Difference%20between%20char%20var

Thanks & Regard!

Pravesh Singh