Unanswered: Read text column into a field to write to a file
I want to write a text column (a column of datatype text) to a variable declared in t-sql. How do I accomplish that?
I know if it is varchar, we can declare a variable of type varchar with a max width of 255. But how do I do the same for text datatype? What is the maximum?