Whenever I’ve needed to break a string across two (or more lines) in the code editor, I’ve always use concatenation to combine multiple strings:

select 'abc' +
'123'

I ran across a code sample that used a slash for a line continuation in our code:

select 'abc\
123'

Both code samples return: abc123

SQL Server Central – Line-continuation in T-SQL