affiliate_link

Friday, August 19, 2011

Difference between varchar(max) and varchar(8000)

Varchar(8000) stores a maximum of 8000 characters

Varchar(max) stores a maximum of 2 147 483 647 characters

Works in SQL Server 2005 or above