题目内容

Your Microsoft SQL Server 6.5 database contains a table named PurchaseOrders that consists of more than 1 million rows.You are developing an application to populate a DataReader object with data from PurchaseOrders. You want to ensure that the application processes the data as quickly as possible.You create a SQL SELECT statement in a local variable named YourSQLSelect You need to instantiate a SqlConnection object and a SqlCommand object that you will use to populate the DataReader object.Which code segment should you use?

2021-12-25

A.Dim myConnection As New OleDbConnection —(rayOleDbConnectionString)Dim YourCommand As New OleDbCommand (YourSQLSelect)

B.Dim myConnection As New OleDbConnection (myOleDbConnectionString)Dim YourCommand As New OleDbCommand (YourSQLSelect, myConnection)

C.Dim myConnection As New SqlConnection _(mySqlConnectionString)Dim YourCommand As New SqlCommand (YourSQLSelect)

D.Dim myConnection As New SqlConnection (mySqlConnectionString)Dim YourCommand As New SqlCommand (YourSQLSelect, myConnection)

题目答案

查看最佳答案免验证查看最佳答案

试卷相关题目

SQL Error: select id,body,options from ***_enewstiku where sourceid='30127' and id < 2437977 and id<>'2437977' order by id desc limit 5 SQL Error: select id,body,options from ***_enewstiku where sourceid='30127' and id > 2437977 and id<>'2437977' order by id asc limit 5