I have a basic doubt in SQL Server 2005. If we declare a column with varchar(8000) then we can insert upto 8000 characters into that column. If we declare varchar(max) then we can insert upto (2 ^ 31)-1 characters into that column.
My doubt is why we are unable to declare varchar(8001) onwards. varchar datatype supports upto 2^31-1 characters but unable to give varchar(8001).
Pls forgive me for this silly question...