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

sql-server character-encoding ssms

Ronnie Overby · Jun 18, 2009 · Viewed 107.9k times · Source

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?

Answer

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