Trying to understand CHAR(10) and CHAR(13) in SQL Server CR (13) + LF (10) combine to create 1 total carriage return If you do it in the opposite order, the LF forces the CR to be on a new line, producing 2 carriage returns It's why in Visual Basic, for example, they call it vbCrLf Always put the carriage return first If you're just printing stuff in SSMS, though, you only need one or the other
Difference between chr (13) and chr (10) - Stack Overflow Chr(10) is the Line Feed character and Chr(13) is the Carriage Return character You probably won't notice a difference if you use only one or the other, but you might find yourself in a situation where the output doesn't show properly with only one or the other So it's safer to include both