We can rename the column name in SQL Server by executing the inbuilt procedure sp_RENAME by giving 3 parameters
1) Table with ColumnName_old
2) Table with ColumnName_new
3) Object we are changing, in this case it is COLUMN
All the above 3 must be enclosed in single quotes as there are string parameters to the calling procedure.