SQL Server: Copying column within table

Question

What is the easiest way to copy the all the values from a column in a table to another column in the same table?

score 50 · Accepted Answer · answered Oct 06 '08 at 09:50

50

With a single statement (if the columns have the same datatype)

UPDATE <tablename>
SET <destination column name> = <source column name>

answered Oct 06 '08 at 09:50

Panagiotis Korros

Is this supposed to create the new column ? – yucer Apr 07 '16 at 09:50
NOTE: You need to have the destination column already created. – TTS Dec 03 '19 at 23:44

score 15 · Answer 2 · answered Oct 06 '08 at 09:50

15

This script will update ALL values in the field1 with the values from the field2 in the corresponding row

UPDATE table SET field1 = field2

answered Oct 06 '08 at 09:50

Ilya Kochetov

2 Answers2