Sometimes you want to paste a block of text or HTML code inside a table of SQL Server using the SQL Server Managment Studio. Problem is that usually the text or code has line breaks in it, resulting in truncation of the pasted text.

A solution that i found to the problem above was to use a text editor like Notepad++. You first paste the text or Html code inside notepad++, mark the text and use the command “join lines” from the edit menu.  In that case, notepad++ removes the line breaks and you have one line of text. That is the text that you want to paste into the cell of the SQL Server Table in order not to have problems with truncation.