Executes the specified pass-through query on the specified linked server. This server is an OLE DB data source. OPENQUERY can be referenced in the FROM clause of a query as if it were a table name.
As SQL Server professionals, we frequently need to integrate data from external sources, whether it's another SQL instance, an Oracle database, or even a simple MS Access file. SQL Server provides two ...
I've got an ASP.NET app w/ a SQL backend. The SQL backend has a linked server (Access db) that is has several views that call from the linked tables. Everything works fine in QA and Enterprise manager ...