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
⇒ CHARINDEX() and SUBSTRING() - Locating and Taking Substrings in SQL Server
⇐ Character String Functions Supported by SQL Server 2005 in SQL Server
⇑ Character Strings and Binary Strings in SQL Server Transact-SQL
2022-05-12, 5779🔥, 1💬
Popular Posts:
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...