Insert contents from #Temp table into real table

Question

I have a temp table where i have changed some values in the database and am trying to nsert these back into the real table but it is not working I have this below:

SELECT * INTO dbo.PackageProduct FROM #PackageP

where #PackageP is my temp table

I am getting this error after the second run:

There is already an object named 'PackageProduct' in the database.

[INSERT INTO vs SELECT INTO](http://stackoverflow.com/questions/6947983/insert-into-vs-select-into) — bummi, Sep 04 '14 at 15:12

score 4 · Accepted Answer · answered Sep 04 '14 at 15:10

4

If the table already exists you have to use INSERT as SELECT...INTO creates a new table:

INSERT dbo.PackageProduct (<columns...>)
SELECT (<columns...>) FROM #PackageP

answered Sep 04 '14 at 15:10

jpw

44,361
6
66
86

score 1 · Answer 2 · answered Sep 04 '14 at 15:12

1

TRY

INSERT INTO dbo.PackageProduct SELECT * FROM #PackageP

answered Sep 04 '14 at 15:12

SRahmani

348
1
5
17

2

It would be beneficial to everyone if you added some explanation. – Huangism Sep 04 '14 at 15:36

score 0 · Answer 3 · edited Sep 04 '14 at 15:15

0

Assuming you've got the same number and order of columns in both tables try this:

INSERT INTO dbo.PackageProduct
SELECT *
FROM #PackageP

edited Sep 04 '14 at 15:15

Dave.Gugg

6,561
3
24
43

answered Sep 04 '14 at 15:14

Piotrek

3
3

score 0 · Answer 4 · answered Sep 04 '14 at 15:15

If you do select * into ... it will create a table, if the same name already exist then it will show error, and the error clearly identifies that there is already a object (table/view/proc... ) in the database. check with some other name or check the existing object is not required then drop it and then use your query or insert it into the table(if both your temp table and the existing object structure is same and it is a table).

Insert contents from #Temp table into real table

4 Answers4