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:PRINT N'Same Line';
displays the following in the “Messages” tab:Same
But, add in the backslash (well, a space and then a backslash so that it looks right):PRINT N'Same \ Line';
and now the following is displayed in the “Messages” tab:Same Line
Read on for more details.