SQL Server has a limitation where it can't use remote tabular functions from linked servers directly in its own queries. To overcome this limitation, use the OpenQuery function to run a query on the ...

OPENQUERY (Transact-SQL) [!INCLUDE SQL Server - ASDBMI] Executes the specified pass-through query on the specified linked server. This server is an OLE DB data source. OPENQUERY can be referenced in ...

I am trying obtain some data from a Cache database into a Mysql database using Cache's SQL Gateway.Getting the data out of Cache is easy, but I am not sure about the easiest way to get it into ...