Check out the OPENROWSET function in T-SQL:
OPENROWSET
Includes all connection information necessary to access remote data from
an OLE DB data source. This method is an alternative to accessing tables
in a linked server and is a one-time, ad hoc method of connecting and
accessing remote data using OLE DB. The OPENROWSET function can be
referenced in the FROM clause of a query as though it is a table name.
The OPENROWSET function can also be referenced as the target table of an
INSERT, UPDATE, or DELETE statement, subject to the capabilities of the
OLE DB provider. Although the query may return multiple result sets,
OPENROWSET returns only the first one.
OPENROWSET ( 'provider_name'
, { 'datasource' ; 'user_id' ; 'password'
| 'provider_string' }
, { [ catalog. ] [ schema. ] object
| 'query' }
)
Mark
-----Original Message-----
From: James Smith [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 06, 2006 6:17 AM
To: CF-Talk
Subject: RE: Cross-Server Joins
> I have heard tell that it is possible to perform cross-database and
> even cross-server joins in MSSQL but I can't find any good info on how
> it is done. Can someone point me in the right direction, specifically
> for the cross server stuff?
Before you reply, my mistake. By cross-server I should have said
cross-platform. I am trying to link a MySQL database into MSSQL.
I have found several references online but none of them work so I was
wondering if any of you had experience.
--
Jay
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252202
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
