How you get new line or line feed in Sql Query ?
4 Answers
Pinal Dave explains this well in his blog.
DECLARE @NewLineChar AS CHAR(2) = CHAR(13) + CHAR(10) PRINT ('SELECT FirstLine AS FL ' + @NewLineChar + 'SELECT SecondLine AS SL') -- Access: SELECT CHR(13) & CHR(10) -- SQL Server: SELECT CHAR(13) + CHAR(10) You could do Char(13) and Char(10). Cr and Lf.
Char() works in SQL Server, I don't know about other databases.
use CHAR(10) for New Line in SQL
char(9) for Tab
and Char(13) for Carriage Return
