declare @string5 varchar(40)= @text1 + char(13) + char(10) + @text2;
select @string5;

或者:

declare @string6 varchar(40)= @text1 + '
' + @text2;
select @string6;