SQL-SERVER OPENQUERY

    to use linked-server in sql-server : 
    SELECT * FROM OPENQUERY([SERVER_NAME], 'SELECT * FROM DATABASE_NAME..TABLENAME')