Status: Solved
Priority: Medium
Security: Public
Views: 335
Last Modified: 2013-11-29

Use two database for select and insert

Dear Experts,
I have two different databases. need to connect one to get data and second to insert.

Insert into abc.dbo.a(ID)
Select id from xyz.dbo.d(id)

How i could execute this task please guide

Mehram

Asked: 2013-11-29

Advertise Here

Microsoft SQL Server 2008

1 Solution

LVL 9

guswebbCommented: 2013-11-29

SELECT [xyz].[dbo].[d].[id] INTO [abc].[dbo].[a]

MehramAuthor Commented: 2013-11-29

Sir, the both table already exist. Into will create another table I need make join between both databases to get result and insert into the particular table.

LVL 9

guswebbCommented: 2013-11-29

INSERT INTO [abc].[dbo].[a] (id) SELECT id FROM [xyz].[dbo].[d]

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Use two database for select and insert

Join & Write a Comment Already a member? Login.

Featured Post