In SQL-Server 2008, how do I create a table of strings where the column-sizes are dynamically generated?

In SQL-Server 2008, I have a table of strings. I would like to create another table of strings that dynamically creates the size of the target fields to that of the already populated source fields. How can this be achieved?
Who is Participating?
in Sql you can define a column as varchar(MAX) this create a column which size grow depends of the values inserted
please give an exxample...

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.