Linked Server in the SQL Statement

Question

Illustrates the term Linked Server in the SQL Statement?

Answer 1

SQL Server can use distributed query within the SQL Statement by using Linked Server as follows:

• This is the virtual server which is created to access OLE DB data source.

• This includes all the information required to access OLE DB data source.

• Linked server definition has all the information required to locate OLE DB data source.

• You can join local data and remote data by using Linked Server.