for example
my Table Name : table_name
Old Column Name : "OldColumn"
New Column Name : "NewColumn"
EXECUTE sp_rename N'dbo.table_name.OldColumn', N'Tmp_NewColumn', 'COLUMN'
GO
EXECUTE sp_rename N'dbo.table_name.Tmp_NewColumn', N'NewColumn', 'COLUMN'
GO
This code change your column name and remain column values as it is.