General information
Forum:
Microsoft SQL Server
Title:
Copying records from one database to another
Environment versions
SQL Server:
SQL Server 2000
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only