My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/when is varchar(max) not a varchar(max)
The new RSS feed is here
I was looking into a question raised at the lauanch about the best way to pass large sets of values to sql. Currently the person is restricted by the 8000 character limit for a varchar in SQL 2000. A number of options where mentioned including bulk inserting, xml, a user defined type and a varchar(max).
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/when is varchar(max) not a varchar(max)