Have Geek Brain

Sql Server Management Studio 2008 - Insert Row with More than 2 Rows

I want to insert a row with more than 2 rows in an nvarchar (max) cell (right click the table in Sql Server Management Studio 2008 -> Edit Rows). Unfortunately, only the first line of the row is inserted into the cell.

I know I could write an Insert / Update script to do this, but that's not what I'm looking for. I need a quick way to insert some text into some cell.

Is there a way to achieve my goal?

Thanks in advance.

+2


a source to share


1 answer


It looks like this is not possible at the moment, but Microsoft is looking into it:



http://connect.microsoft.com/SQLServer/feedback/details/415157/copy-paste-of-row-with-multi-line-text-in-management-studio-2008-results-in-corrupted-data

+1


a source






More articles:


All Articles