Sql Server Datatype Of Text Does Not Maintain Formatting

I have to use a column with a datatype of TEXT in SQL Server 2005 to store a string that I need formatted with newlines and tab character for example. prior to calling the stored p

Solution 1:

It does preserve the formatting fine, you're losing the format by copying out of the SSMS cell.

Once you've got code pulling the text back out you should still have the formatting in place.

For example if you run the following in SSMS, you'll lose the newlines. It switches in spaces for other whitespace chars I think.

Select'
This
    is
some fomatted
text'

Solution 2:

You could enable "Retain CR/FL on copy or save" Option.

Tools--> Options--> Query Result --> SQL Server--> Result To Grid