Insert into certain columns

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 http://msdn.microsoft.com/en-us/library/ms174335(v=sql.90).aspx — Jodrell, Jun 18 '12 at 16:54

score 33 · Accepted Answer · answered Jun 18 '12 at 16:51

33

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

answered Jun 18 '12 at 16:51

score 5 · Answer 2 · answered Jun 18 '12 at 16:52

5

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

answered Jun 18 '12 at 16:52

bnvdarklord

score 2 · Answer 3 · answered Jun 18 '12 at 16:51

2

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

answered Jun 18 '12 at 16:51

Taryn

score 1 · Answer 4 · answered Jun 18 '12 at 16:51

1

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

answered Jun 18 '12 at 16:51

Shyju

score 1 · Answer 5 · answered Jun 18 '12 at 16:52

1

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

answered Jun 18 '12 at 16:52

5 Answers5