Detect line break in SQL query

To detect a line break within a SQL query, the below script will replace line breaks with a tilde (~).

SELECT REPLACE(Notes, CHAR(10), '~')
FROM Table


Other characters you may want to replace:
Tab -> char(9)
Line feed -> char(10)
Carriage return -> char(13)

SQL Update column name

exec sp_RENAME 'table.column', 'newName', 'COLUMN';

example:
exec sp_RENAME 'Employee.notes' , 'payNotes', 'COLUMN';

Caution: Changing any part of an object name could break scripts and stored procedures.