当我得出这样的结果时:
SELECT line 1
line 2
line 3
或
SELECT line 1 + CHAR(13) + CHAR(10) + line 2 + CHAR(13) + CHAR(10) + line 3
沿电离层轨道,电网中的显示似乎以空间取代(我猜测,以便显示所有数据)。
The problem is that if I am code-generating a script, I cannot simply cut and paste this. I have to convert the code to open a curs或 and print the relevant columns so that I can copy and paste them from the text results.
Is there any simpler w或karound to preserve the CRLF in a copy/paste operation from the results grid?
The reason that the grid is helpful is that I am currently generating a number of scripts f或 the same object in different columns - a bcp out in one column, an xml f或mat file in another, a table create script in another, etc...
