How to connect two database in one statement - Support Queries

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleBackup for SQL Server (2000, 2005, 2008, 2012) » Support Queries » How to connect two database in one statement

How to connect two database in one statement

Options · View

Previous Topic · Next Topic

siamtownusc

Posted: Friday, October 15, 2010 9:23:26 PM

Rank: Newbie
Groups: Member

Joined: 10/15/2010
Posts: 1
Points: 3
Location: siamtownusc

i have two database in my account,
how to select database form both in single statement
by using [servername].dbo.[tablename].[fieldname]

elian

Posted: Thursday, October 21, 2010 7:59:20 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

As soon as your credentials give you access to the both db :

SELECT * FROM db1.owner.table1, db2.owner.table2

Users browsing this topic

Guest

myLittleTools Community Forum » myLittleBackup for SQL Server (2000, 2005, 2008, 2012) » Support Queries » How to connect two database in one statement

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.