Copying records from one database to another - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Copying records from one database to another

Message

From

25/01/2006 14:33:36

Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom

To

19/01/2006 14:27:41

Sergey Berezniker
New York, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Copying records from one database to another

Environment versions

SQL Server:

SQL Server 2000

Miscellaneous

Thread ID:

01088584

Message ID:

01090252

Views:

10

Hello Sergey,

>

INSERT INTO db2.dbo.table2 SELECT * FROM db1.dbo.table1

That does the trick - many thanks.

Regards,
Alan

Click here to load this message in the networking platform