| |
| |
|
|
T-SQL Distributed Queries and Transactions
|
Distributed Queries - Distributed queries access data from multiple
heterogeneous data sources, which can be stored on either the same or
different computers. Microsoft SQL Server supports distributed
queries by using OLE DB, the Microsoft specification of an application
programming interface (API) for universal data access.
Distributed Queries and Distributed Transactions - Microsoft SQL
Server allows you to create links to OLE DB data sources called linked
servers. After linking to an OLE DB data source, you can reference
rowsets from the OLE DB data sources as tables in Transact-SQL
statements.
Transact-SQL Distributed Transactions - The Transact-SQL statements
controlling the distributed transactions are few because most of the
work is done internally by Microsoft SQL Server and MS DTC.
|
|
|
|
|