VB向SQLSERVER插入记录

Private Sub Command2_Click()
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
conn.ConnectionString = "Driver={sql server};server=QIANY;uid=;pwd=;database=stock"
conn.ConnectionTimeout = 30
conn.Open
rs.Open "select * from HQ", conn, adOpenStatic, adLockBatchOptimistic
rs.AddNew
    rs!DaiM = "600011"
rs.AddNew
    rs!DaiM = "600012"
rs.AddNew
    rs!DaiM = "600013"
rs.UpdateBatch
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
MsgBox "ok"
End Sub 

————————————————————

以上两个需对应:adLockBatchOptimistic,UpdateBatch说明可以一次性插入多条记录

使用adLockOptimistic，update结合也可以，但只能单条添加