Insert into certain columns [duplicate]

Question

Im using SQL Server 2005.

I have a table1 with 3 columns. And table2 with 4 columns.

I want to insert the records from table1 into table2.

But I dont want to insert into column1 from table2.

I want to start inserting from column2 on.

What can i do? Thanks...

You could always look it up msdn.microsoft.com/en-us/library/ms174335(v=sql.90).aspx — Jodrell
– Jodrell, Commented Jun 18, 2012 at 16:54

user596075 · Accepted Answer · 2012-06-18 16:51:24Z

32

insert into table2 ( col2, col3, col4 ) select col1, col2, col3 from table1

answered Jun 18, 2012 at 16:51

user596075

Sign up to request clarification or add additional context in comments.

Comments

bnvdarklord · Accepted Answer · 2012-06-18 16:52:36Z

You can combine select and insert in order to do this. This is how:

insert into table2 (col2, col3, col4) select col1, col2, col3 from table1

Taryn · Accepted Answer · 2012-06-18 16:51:35Z

You will just need to use a SELECT...FROM in your INSERT to select the columns you want.

INSERT INTO table2 ( column2, column3, column4 ) SELECT column1, column2, column3 FROM table1

Shyju · Accepted Answer · 2012-06-18 16:51:57Z

1

INSERT INTO Table2 (column2,colum3,column4 ) SELECT column1,column2,column3 FROM Table1

answered Jun 18, 2012 at 16:51

220k106 gold badges420 silver badges499 bronze badges

Srinivas Reddy Thatiparthy · Accepted Answer · 2012-06-18 16:52:00Z

1

into into table2 (column2,......) select column2 ..... from table1

answered Jun 18, 2012 at 16:52

11.2k4 gold badges48 silver badges68 bronze badges