How to retrieve information from SQL table in Linked SQL Server

Retrieve information from SQL table in Linked SQL Server

SELECT FROM Sql Statement can be used to retrieve information from SQL table in Linked SQL Server. We need to specify below in front of SQL table name :

1. Name of Linked Server
2. Name of Database
3. Database owner name

Example :

Employee table exists in EmpDB database in Linked Server named "EmpCorp"

Employee information can be retrieved by below Select SQL query :

SELECT *
FROM EmpCorp.EmpDB.dbo.Employee