Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is a pass-through query?

April 26, 2017pass-through query

0

Posted

What is a pass-through query?

1 Answer

0

Posted

Microsoft® SQL Server 2000 sends pass-through queries as un-interpreted query strings to an OLE DB data source. The query must be in a syntax the OLE DB data source will accept. A Transact-SQL statement uses the results from a pass-through query as though it is a regular table reference. This example uses a pass-through query to retrieve a result set from a Microsoft Access version of the Northwind sample database. SELECT * FROM OpenRowset(‘Microsoft.Jet.OLEDB.4.0’, ‘c:\northwind.