select into

ginoitalo · June 6th, 2004, 01:20 PM

select * INTO db2..t1 from db1..t1

I get:
Server: Msg 2714, Level 16, State 6, Line 2
There is already an object named 't1' in the database.

't1' does exist, I can't delete it, i just wnat to select into it !

melvik · June 6th, 2004, 11:06 PM

What is it?! [u]Select</u> HAS no INTO what do u want to do?!

Always:),
Hovik Melkomian.

bmains · June 7th, 2004, 07:17 AM

Hello,

Try select * into db2.dbo.t1 from db1.dbo.t1

Please note that the user performing the insert operation must have dbo privileges to insert into a different database.

Brian

planoie · June 7th, 2004, 09:06 AM

If you want to "SELECT INTO..." an existing table, try INSERT:

INSERT INTO db2..t1
SELECT * FROM db1..t1

happygv · June 7th, 2004, 08:08 PM

Hi Ginoitalo,

Select * INTO .... copies the structure and rows from an exisiting table/given QUERY to a non exisiting target table. In this case the target table is created and should not pre-exist.

Insert INTO .... Copies only the rows from the QUERY that follows.
In this case the target table should exist(atleast the structure) to have the rows copied into.

Melvik,
Select has an INTO clause in it. With INTO, it the output of the query is destined to a table mentioned after INTO. Pls check BOL under Index "SELECT : Clauses" >> "described".

Code:

SELECT select_list
[INTO new_table_]
FROM table_source
[WHERE search_condition]
[GROUP BY group_by_expression]
[HAVING search_condition]
[ORDER BY order_expression [ASC | DESC] ]

Hope that helps.
Cheers!

_________________________
-Vijay G

Strive for Perfection