asp 預存程序

 

  　　set objComm = Server.CreateObject("adodb.command")
  　　objComm.CommandType = 4
  　　objComm.ActiveConnection = conn
  　　objComm.CommandText = "預存程序名字" 
  　　objComm.Prepared = true 
  　　objComm.Parameters.append objComm.CreateParameter("@field",200,1,50,getfield)
  　　objComm.Parameters.append objComm.CreateParameter("@tablename",200,1,50,"test_table") 
  　　objComm.Parameters.append objComm.CreateParameter("@fieldname",200,1,50,"mc")
  　　objComm.Parameters.append objComm.CreateParameter("@filter",200,1,100,"scdc_id="&rs("scdc_id"))

  　　Set oRs = objComm.execute

　　 ....