\ (Backslash) (Transact-SQL)
Applies To: SQL Server 2014, SQL Server 2016 Preview
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>
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.