Microsoft® SQL Server 2012 Unleashed

Distributed Queries

Distributed queries access data stored in OLE DB data sources. SQL Server treats these data sources as if they contained SQL Server tables. Basically, via a provider such as OLE DB, the data source is put in terms of recordsets. Recordsets are the way SQL Server needs to see any data. The Microsoft SQL Native Client OLE DB provider (with PROGID SQLNCLI) is the official OLE DB provider for SQL Server 2012. You can view or manipulate data through this provider by using the same basic Data Manipulation Language (DML) syntax as for T-SQL for SQL Server (SELECT, INSERT, UPDATE, or DELETE statements). The main difference is the table-naming convention. Distributed queries use a four-part table name syntax for each data source as ...