Which of the following function mainly used for bulk load data is referenced…
2026
Which of the following function mainly used for bulk load data is referenced in the following code?
SELECT
RemoteOrders.*
FROM
OpenRowset("Microsoft.Jet.OLEDB.3.51",
"c:\brian\writing\sqlservermag\nov98\nwind.mdb"; "admin"; ,
"select * from orders") RemoteOrders
LEFT JOIN MasterOrders ON
RemoteOrders.OrderId = MasterOrders.OrderId
WHERE
MasterOrders.OrderID = NULL
Answer: A. OpenRowset — Answer: a Explanation: The OPENROWSET function can be referenced in the FROM clause of a query as if it were a table name.
- A.
OpenRowset
- B.
Microsoft.Jet.OLEDB
- C.
admin
- D.
All of the mentioned
Attempted by 252 students.
Show answer & explanation
Correct answer: A
Answer: a
Explanation: The OPENROWSET function can be referenced in the FROM clause of a query as if it were a table name.
Loading lesson…