How do I add line breaks to a field in SQL Server Management Studio

=========
QUESTION
———
How do you add a line break when editing a field in a database using SQL Server Management Studio 

 

=========
ANSWER
———
We have not found a simple way to do this using SQL Server Management Studio (SSMS) alone.
Instead, you can use the free Notepad++ text editor and add your text in there, and then paste it back into the field in SSMS.

Download Notepad++ from
http://notepad-plus-plus.org

Go to Settings, Preferences, and select the New Document/Default Directory tab. 
Set the Format option to Unix, and click Close

Close Notepad++ and open it again.
Type the text you need and then copy and paste it into the field in SSMS.

Line breaks will be maintained. 

 

=========
EXAMPLES
———

 

=========
APPLIES TO / KEY WORDS
———
SSMS
SQL Server Management Studio 2008 

 

=========
REF
———
http://stackoverflow.com/questions/1014447/how-to-type-a-new-line-character-in-sql-server-management-studio 

 


http://anySiteSupport.com
http://anySiteHosting.com

By | 2017-12-01T23:47:28+00:00 December 31st, 2012|Computers, Documentation, Microsoft, SQL|0 Comments