Over a million developers have joined DZone.

Query And Join Tables Across Server Instances.

DZone's Guide to

Query And Join Tables Across Server Instances.

Free Resource
Use the following to query or join tables on remote servers.  The query must be executed on a system running SQL Server, but the remote system can be pretty much anything an ODBC driver exists for:

select * from OpenDataSource(’SQLOLEDB‘,’Data Source=server.asdf.com;User ID=yourusername;Password=yourpassword‘).somedatabase.dbo.sometable;

Opinions expressed by DZone contributors are their own.


Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.


{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}