Ask the Expert

Using three part names to reference data in a separate database

I want to create tables from one database into another database through a stored procedure- eg: I want to create all the tables in Pubs that are created on a particular date into my Northwind database (all the data that were in Pubs table must be duplicated into the Northwind database tables) - how is this done?

    Requires Free Membership to View

You need a query like the following:


CREATE PROC dbo.CopyAuthors
AS
SELECT * INTO Northwind.dbo.authors
FROM authors
GO

EXEC dbo.CopyAuthors
GO

This was first published in January 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: