The Execute method executes a specified query, SQL statement, stored procedure, or provider-specific text.
Execute的作用是：执行一个查询语句、陈述语句、程序或技术提供对象[provider]的详细文本。

The results are stored in a new Recordset object if it is a row-returning query. A closed Recordset object will be returned if it is not a row-returning query.
如果返回行[row-returning]查询语句，那么结果将被存储在一个新的记录对象中；如果它不是一个返回行[row-returning]查询语句，那么它将返回一个关闭的记录对象。

Note: The returned Recordset is always a read-only, forward-only Recordset!
注意：返回的Recordset是一个只读的、只向前兼容的Recordset。

Tip: To create a Recordset with more functionality, first create a Recordset object. Set the desired properties, and then use the Recordset object's Open method to execute the query.
提示：在第一次创建Recordset对象时，需要将它创建为一个更具功能性的Recordset对象。设置一个我们所希望的属性，使用Recordset对象的Open方法去执行查询语句。

Syntax for row-returning
row-returning[返回行]语法

Set objrs=objconn.Execute(commandtext,ra,options)

Syntax for non-row-returning
non-row-returning[非返回行]语法

objconn.Execute commandtext,ra,options

Parameter参数

Description描述

commandtext

Required. The SQL statement, stored procedure, or provider-specific text to execute
必要参数。指定需要执行的SQL语句，现存的程序或技术提供对象[provider]的详细文本

ra

Optional. The number of records affected by the query
可选参数。返回查询语句执行的记录数

options