How do I duplicate a column in a SQL Table?

Question

I am using SQL Server 2014 and I have a table named Table1. Assuming I want to duplicate a column named SubCategory into a new column called SubCategory2 (with the same values as in column SubCategory), what would be the SQL syntax to do this?

Note: Idea here is to keep column Subcategory but create another column SubCategory2 and modify some specific values in that new column.

Example (assuming Table1 has only 2 columns):

Serial Subcategory 1 UK 2 UK 3 FR 4 DE

Expected output:

Serial Subcategory Subcategory2 1 UK UK 2 UK UK 3 FR FR 4 DE DE

kabanus · Accepted Answer · 2019-04-21 07:52:22Z

A combination of Add a column with a default value to an existing table in SQL Server and How can I copy data from one column to another in the same table? woold look something like:

ALTER TABLE Table1 ADD SubCategory2 {Type of subcategory 1} {NULL|NOT NULL} UPDATE Table1 SET SubCategory2 = SubCategory;

Cody Gray · Accepted Answer · 2020-07-27 07:54:55Z

1

select * from Table1 ---------Query----------- select * , SubCategory as SubCategory2 FROM Table1 ----------------------

edited Jul 27, 2020 at 7:54

Cody Gray♦

246k53 gold badges512 silver badges591 bronze badges

answered Apr 22, 2019 at 5:19

Ravi Sharma

3801 silver badge5 bronze badges

Comments

Himanshu · Accepted Answer · 2019-04-21 08:00:15Z

Use case instead when selecting records

 SELECT Serial ,Subcategory, case when Subcategory='somevalue' then Subcategory else null end 'Subcategory2' from table

Eugene Ogongo · Accepted Answer · 2019-04-21 07:59:07Z

-2

 use ['database name'] go insert into table1 ('subcategory2') select subgategory from table1;

edited Apr 21, 2019 at 7:59

answered Apr 21, 2019 at 7:52

Eugene Ogongo

3753 silver badges12 bronze badges

2 Comments

Tsahi Asher Over a year ago

This will add new rows, and not update existing rows.

Eugene Ogongo Over a year ago

Can you check example and expected out of the question. I think I have answered it as per the example is given.

Collectives™ on Stack Overflow

How do I duplicate a column in a SQL Table?

4 Answers 4

Comments

Comments

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

2 Comments

Linked

Related