How to type a new line character in SQL Server Management Studio

Question

In the "datagrid" view of an open table of data, how can I type a new line character into an nvarchar field directly in SSMS?

Is there an alt code?

question from:https://stackoverflow.com/questions/1014447/how-to-type-a-new-line-character-in-sql-server-management-studio

Answer 1

You can't.

Use a "new query" window instead, and do a manual update:

UPDATE mytable
SET textvalue = 
'This text
can include
line breaks'
WHERE rowid = 1234