O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required