更新时间:2023-01-18 16:58:17
您可以这样做,以允许您重用参数
You can do this, to allow you to reuse parameters
objCmd.CommandText = "declare @var1 int, @var2 int, @var3 int; " & _
"select @var1 = ?, @var2 = ?, @var3 = ?;" & _
"select ... where field1 = @var1 or field4 = @var1 or field2 = @var2 ... "
并按正常顺序添加参数.
and add the parameters in the normal ordered manner.