Line termination literals

Windows-based systems use the two-character combination “carriage return, new line” at the end of a line of text. To produce this literal for inclusion in strings (for example as a string concatenation separator), use CHAR(13) + CHAR(10). For example:

SELECT 'FirstLine' + CHAR(13) + CHAR(10) + 'SecondLine'