1 Jun

Selecting data from different databases in SQL queries

Category: SQL Server, SQL Server 2005

realy easy:

select * from forum.dbo.tblauthor

select * from [database-name].[owner].[table]

Also useful to point out that if you are selecting from a database with - or other characters in the name then just use [:

select * from [rails-07-2].dbo.tblauthor

EASY!

Posted Friday, June 1st, 2007 at 9:26 pm
Filed Under Category: SQL Server, SQL Server 2005
Responses are currently closed, but you can trackback from your own site.

0

Comments are closed.