How to Duplicate Column in same table in SQL
Depending on other requirements, you might be able to get away with using a computed column. This assumes you don't need to manipulate the data in the duplicated column.
ALTER TABLE dbo.t
    ADD NewColumn AS OldColumn;