Varchar(Max) limit of max in Sql2005 ?


While developing one store proc i face problem of varchar(max)

my string was genreated more than 100000 charactes and by default varchar(max) size is 65,536

actual size of any max type is 2^30-1
if you place max text size is 1 then it set to max available size

Leave a Reply

I'm Yogesh Kadvekar, a Technology Consultant, Computer Engineer by education, tech writer and problem solver. I love startups. I love hiking, sports, arts and Stock market. Say hello!

%d bloggers like this: