Querying data from a remote SQL Server

To query data from a remote SQL Server you need to first setup a linked server. Then you can query the linked server by using the following command:

SELECT *
FROM linked-server.database-name.schema-name.table-name