Que: 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
a. OpenRowset
b. Microsoft.Jet.OLEDB
c. admin
d. All of the mentioned
Answer: OpenRowset

Leave a Comment