line breaks for SQL Server print statements

Text: line break for SQL Server print statements

line breaks for SQL Server print statements

You want to wrap the print statement in the output, you can do this

/*Line Wrap tab for SQL char (9) newline character char (10) Carriage return char (in)*/PRINT 'Test'+CHAR( -)+'Name'PRINT 'Test'+CHAR(Ten)+' Age'PRINT 'Test'+CHAR(9)+'Tel'--display results in text FormatSELECT 'AAA'+ CHAR(Ten)+'BBB'--AAA BBBSELECT 'AAA'+ CHAR( -)+'BBB'--AAA BBBSELECT 'AAA' + CHAR(Ten)+ CHAR( -)+ 'BBB'--AAA BBB

Output effect:

Reference: http://blog.csdn.net/lanqiao825/article/details/6227878

line breaks for SQL Server print statements