7,764
社区成员
发帖
与我相关
我的任务
分享
Dim cnn As ADODB.Connection
Dim cmd As ADODB.Command
Dim prmID As ADODB.Parameter
Dim prmName As ADODB.Parameter
Dim i As Long
...
Set cmd = New ADODB.Command
cmd.CommandText = "INSERT INTO t1 (id,name) VALUES(?,?)"
Set cmd.ActiveConnection = cnn
cmd.Prepared = True '仅对 SQL 进行首次解析
Set prmID = cmd.CreateParameter("id", adInteger, adParamInput)
cmd.Parameters.Append prmID
Set prmName = cmd.CreateParameter("name", adVarChar, adParamInput, 10)
cmd.Parameters.Append prmName
For i = 1 To 10000
prmID.Value = i
prmName.Value = CStr(i)
cmd.Execute
Next