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.
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.
sql server查询结果复制出来，没有换行(存进去的数据是换行的)
原文：https://www.cnblogs.com/chucklu/p/10998184.html