sql server查询结果复制出来,没有换行(存进去的数据是换行的)
https://stackoverflow.com/questions/53115490/how-to-correctly-insert-newline-in-nvarchar
The problem is your setting on SSMS, not that the data doesn't have a line break.
Go to: Tools -> Options -> Query Results -> SQL Server -> Results to Grid -> Retain CR/LF on copy or Save
and make sure the option is ticked.