Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SELECT * INTO table IN db 4

Status
Not open for further replies.
Trevoke

Trevoke

Programmer
Joined
Jun 6, 2002
Messages
1,142
Location
US
I am using SQL 2k.
I have two db (db1 and db2) on the server SERVER1.
Table1 is in db1.

I want to create a copy of table1 in table2 on db2..

use db1
select * into table2 in db2
from table1

gives me 'incorrect syntax near the keyword 'IN'.

The examples I found online say I have to do 'db2.db' or 'db2.mdb' ... Is that a reference to a file? I don't want to run something I don't understand..

Tao Te Ching Discussions : Chapter 9 (includes links to previous chapters)
What is the nature of conflict?
 
Sort by date Sort by votes
I am using SQL 2k
So, please, post in a SQL Server forum.
forum183

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
This is the forum for SQL Server Programming questions:
forum183

However, the answer to your question is the following:
Code: 
USE db1
SELECT * INTO db2.dbo.Table2
FROM Table1

Replace dbo with the name of another schema if needed.
 
Upvote 0 Downvote
This forum is for SQL coding questions when you are coding to one of the ANSI SQL standards. Basically, it means writing SQL which may be executed successfully on any database system which follows the standard.
 
Upvote 0 Downvote
So what is this forum for?
faq220-1073

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
the other reason you should post in the right forum is because ANSI SQL solutions aren't always appropriate

SELECT INTO, for example, is ~not~ ANSI SQL



r937.com | rudy.ca
Buy my new book Simply SQL from Amazon
 
Upvote 0 Downvote
the proper way:

1. CREATE TABLE db2.dbo.Table2 ( ...

2. INSERT INTO db2.dbo.Table2 SELECT ... FROM db1.dbo.table1

:-)

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question Question
Cross Join in an Insert Into
Replies
1
Views
586
carp
carp
sal21
  • Locked
  • Question Question
SELECT COUNT distinct
Replies
5
Views
724
sal21
sal21
mmiah1982
  • Locked
  • Question Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
563
mmiah1982
mmiah1982
BobThornton
  • Locked
  • Question Question
windows command in a sql script
Replies
1
Views
606
carp
carp
harfri
  • Locked
  • Question Question
Insert into a new table
Replies
0
Views
440
harfri
harfri

Part and Inventory Search

Sponsor

Back
Top