I have a long query and for readability I would like this query on multiple lines. For example:
SELECT p.Phone, p.Contacts, p.PhoneNo,p. PhoneType,
ROW_NUMBER() OVER(PARTITION BY p.Contacts ORDER BY P2.Preference) AS RowNumber
FROM Phone AS P
I don't want it all on one line. What is the character to use after each line of code? In C# we use a '+' at the end of each line.