Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

About this user

Greg Miller http://www.principiaprogramatica.com

« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS 

Query and join tables across server instances.

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:
   1  
   2  select * from OpenDataSource(’SQLOLEDB‘,’Data Source=server.asdf.com;User ID=yourusername;Password=yourpassword‘).somedatabase.dbo.sometable;
to sql SQL Server by gmiller on Dec 31, 2006
« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS