OPENQUERY#
Runs a query on a connected source and returns its result set as a table you can use in the FROM
clause. OPENQUERY passes the query text straight through to the source, so you can use that
source’s own SQL dialect.
Syntax#
OPENQUERY ( 'connection', 'query' )
connection— the name of the Querona connection the query runs on.query— the statement to execute on that source, in the source’s native dialect.
Examples#
SELECT * FROM OPENQUERY('sql2012', 'SELECT name FROM sales.customers WHERE id = 100');