Update query in sql server

Question

I have two tables table1 with fields f1, f2

and

table2 with fields id,f1,f2, where id is incremental field

I need to take the values from table1 and need to insert into table2

Can anyone give the query for that,in sql server

mystery · Accepted Answer · 2011-05-04 16:43:17Z

1

INSERT INTO table2(f1,f2) SELECT f1,f2 FROM table1

That will do exactly what you want.

answered May 4, 2011 at 16:43

mystery

19.6k4 gold badges45 silver badges65 bronze badges

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

Comments

Joe Stefanelli · Accepted Answer · 2011-05-04 16:41:47Z

0

INSERT INTO table2
    (f1, f2)
    SELECT f1, f2
        FROM table1

answered May 4, 2011 at 16:41

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

Byron Whitlock · Accepted Answer · 2011-05-04 16:42:04Z

0

Check out select into or insert into

answered May 4, 2011 at 16:42

Byron Whitlock

54.2k29 gold badges128 silver badges170 bronze badges