Applies To: SQL Server (starting with 2008)
Breaks a long string constant into two or more lines for readability.
|Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.|
<first section of string> \ <continued section of string>
<first section of string>
Is the start of a string.
<continued section of string>
Is the continuation of a string.
This command returns the first and continued sections of the string as one string, without the backslash.
The backslash is not a Transact-SQL statement. It is a command that is recognized by the sqlcmd and osql utilities and SQL Server Management Studio Code Editor.
The following example uses a backslash and a carriage return to split the string into two lines.
SELECT 'abc\ def' AS ColumnResult;
Here is the result set.