Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Mar 17, 2000

Copying Table Rows

Question:
I have two databases and two tables in them have the same structure (same columns etc.). How do I copy some rows from one database to another? Both tables have the same structure.

Answer:
Use this:

SELECT xxx from table1 INSERT into table2 WHERE blah-blah-blah
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap