Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copying records from one database to another
Message
From
19/01/2006 14:25:56
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Copying records from one database to another
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01088584
Message ID:
01088584
Views:
61
I wish to copy records from a table in one database (db1.table1) to a similar table in another database (db2.table2), but I am not sure about the syntax.

I guess it would go something like...
INSERT INTO db2.table2 (SELECT * FROM db1.table1), but this does't work.

Any help would be appreciated.

Alan
Next
Reply
Map
View

Click here to load this message in the networking platform