How to Duplicate Column in same table in SQL I'm pretty basic with SQL and need help with the following task:
I already have a table with data in it. What I would like to do is to Duplicate a Column (Including the data) in the same table but with a different column name. Is this possible?
Any help would be greatly appreciated.
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;