CODEWITHSUNDEEP
sql-server-2008ssms
gsharp
gsharp

Reputation: 27927

Sql Server Management Studio 2008 - Insert string with more than two lines

I want to paste a string with more than two lines into a nvarchar(max) cell (right click a Table in Sql Server Management Studio 2008 --> Edit Rows). Unfortunately only the the first line of the string is pasted into the cell.

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

Is there a way to achieve my goal?

Thanks in advance.

Upvotes: 2

Views: 1575

Answers (1)

grimmig
grimmig

Reputation: 1421

Looks like it isn't 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

Upvotes: 1

Related Questions