0

I have a table which acts like a code vault of sorts for an SSIS package.

ID SQL Code
1 SELECT * FROM TBL1
2 SELECT * FROM TBL2
3 SELECT * FROM TBL3

When I copy and paste the code where ID = 1, I get the following SQL Code on 2 lines after I paste:

     SELECT *
     FROM TBL1

A co-worker trying to use the same table, copies and paste the code where ID = 1, he gets the following SQL Code on 1 line: SELECT * FROM TBL1

How do I get my co-worker (when they copy and paste the SQL code) to see the SQL code on 2 lines like I am? Is that an option within the settings?

RBarryYoung
  • 55,398
  • 14
  • 96
  • 137
smul86
  • 401
  • 1
  • 8
  • 22
  • 3
    Does this answer your question? [How to correctly insert newline in nvarchar](https://stackoverflow.com/questions/53115490/how-to-correctly-insert-newline-in-nvarchar/53115559#53115559) – Thom A Aug 18 '21 at 16:41
  • What are you and you coworker pasting it into? – RBarryYoung Aug 18 '21 at 16:49
  • 1
    I suspect the problem is that their coworker doesn't have "Retain CR/LF on copy" switched on, @RBarryYoung . – Thom A Aug 18 '21 at 16:56
  • 1
    [this](https://stackoverflow.com/a/37284582/3987784) might help you. – sacse Aug 18 '21 at 16:58

1 Answers1

0

Answer has been solved in comments for this question. "Retain CR/LF on copy" needed to be switched on. Thank you!

smul86
  • 401
  • 1
  • 8
  • 22