June 4, 2008 by Yogesh Kadvekar
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-1if you place max text size is 1 then it set to max available size
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!