Collections:
Inserting New Line Characters into Strings in SQL Server
How To Insert New Line Characters into Strings in SQL Server Transact-SQL?
✍: FYIcenter.com
If you want to break a string into multiple lines, you need to insert new line characters into the string. With some client tools like SQL Server Management Studio, it is not so easy to insert a new line character.
One work around is to use the CHAR(int) function to generated new line character and other special characters with their code values:
The tutorial examples below gives you a good example
PRINT 'Welcome to '+CHAR(10)+'FYIcenter.com'; PRINT CHAR(10); PRINT 'Current date and time is ' +CONVERT(VARCHAR(20), GETDATE()); GO Welcome to FYIcenter.com Current date and time is May 19 2007 7:30PM
⇒Character Strings and Binary Strings in SQL Server Transact-SQL
2017-03-07, 846👍, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What Do You Need to Connect PHP to MySQL in MySQL? If you want to access MySQL database server in yo...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...