Define distributed queries

Define distributed queries.

Distributed queries access data from multiple heterogeneous sources. These data sources may or may not be stored on the same computer. Distributed queries are most useful when there are multiple databases of varied nature. Hence, distributed queries can be executed over these databases in a secure manner.

Discuss about Distributed Queries.

Distributed queries can access data from different data sources.
These sources can reside on the same server or a different server.
Theycan querymultiple databases.
How Linked server is used to excess external data
A linked server can be considered as another SQL server database running elsewhere. It can be a OLEDB or ODBC data source......
Describe how OPENQUERY function is used to excess external data
OPENQUERY is used to execute the specified query on the linked sever. OPENQUERY can be referenced in from the FROM clause just like a table name.........
How OPENROWSET and OPENDATASOURCE function is used to access external data
OPENROWSET: Includes all connection information that is required to access remote data from an OLE DB data source.......
Post your comment