1.在sql 的table 已經設定 index
2.open 程式語法於下,但是就是不能使用index 去seek,請問是sql 上還要設定,或vb語法有問題
Set cnnDB = New ADODB.Connection
cnnDB.ConnectionString = "driver={SQL Server};" &
"server=nt_sql;uid=sa;pwd="
cnnDB.Open
cnnDB.DefaultDatabase = "ms2"
RSTobJECT.CursorLocation = adUseClient
RSTobJECT.Open "item_batch_no", cnnDB, adOpenKeyset, adLockBatchOptimistic
2.open 程式語法於下,但是就是不能使用index 去seek,請問是sql 上還要設定,或vb語法有問題
Set cnnDB = New ADODB.Connection
cnnDB.ConnectionString = "driver={SQL Server};" &
"server=nt_sql;uid=sa;pwd="
cnnDB.Open
cnnDB.DefaultDatabase = "ms2"
RSTobJECT.CursorLocation = adUseClient
RSTobJECT.Open "item_batch_no", cnnDB, adOpenKeyset, adLockBatchOptimistic
全站熱搜
留言列表