SQL Server 2005 Carriage Return RRS feed

  • Question

  • How do I enable SQL Management Studio to allow me to directly copy text with carriage returns into a table? 


    I know that I can use the CHAR(13) statement when using T-SQL insert/update statements ('some text' + char(13) + 'some more text').


    However when I copy text with carriage returns directly into a table column by right clicking the table, opening the table and editing the row directly, all text after the first carriage return vanishes.  Only the text before the first carriage return is committed.


    Please help.


    Tuesday, February 26, 2008 11:54 AM

All replies

  • It is not vanished. It should be there but you may not be able to see it. click inside the data cell, use arrow keys to move

    Tuesday, February 26, 2008 8:49 PM
  • lol, no it's definitely not there, I'm aware that cells only show a certain amount of characters depending upon how wide you have set the column.


    Wednesday, February 27, 2008 11:06 AM