我用ADO,可以用参数
Dim CmdProc As ADODB.Command
dim sql as string
Dim Connection As Connection sql="select * from mytable"
With CmdProc
.CommandText = Sql
.CommandType = adCmdStoredProc
Set .ActiveConnection = Connection
.Parameters.Append .CreateParameter("value1", adChar, adParamInput, 55, 值)
.Execute Options:=adExecuteNoRecords
Dim CmdProc As ADODB.Command
dim sql as string
Dim Connection As Connection sql="select * from mytable"
With CmdProc
.CommandText = Sql
.CommandType = adCmdStoredProc
Set .ActiveConnection = Connection
.Parameters.Append .CreateParameter("value1", adChar, adParamInput, 55, 值)
.Execute Options:=adExecuteNoRecords
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货