InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
You Want To Include A Carriage Return/linefeed In Your Output From A Sql Script, How Can You Do This? |
|
Answer» The best METHOD is to use the CHR() FUNCTION (CHR(10) is a return/linefeed) and the CONCATENATION function "||". Another method, although it is hard to document and isn?t always portable is to use the return/linefeed as a PART of a quoted STRING. The best method is to use the CHR() function (CHR(10) is a return/linefeed) and the concatenation function "||". Another method, although it is hard to document and isn?t always portable is to use the return/linefeed as a part of a quoted string. |
|