Press "Enter" to skip to content

Line Continuation In T-SQL

Solomon Rutzky shows how line continuation works with SQL Server:

While it is not widely used (at least I have never seen anyone besides myself use it), T-SQL does actually have a line-continuation character: \ (backslash). Placing a backslash at the end of a line within a string literal (or constant as the MSDN documentation refers to it) or binary string will ignore the newline after the backslash. For example:


displays the following in the “Messages” tab:


But, add in the backslash (well, a space and then a backslash so that it looks right):

PRINT N'Same \

and now the following is displayed in the “Messages” tab:

Same Line

Read on for more details.