大家看到这个标题第一个反应是什么，估计是“Access有存储过程吗？”不过我告诉大家，还真的有，下面就是我 从Access的帮助文件里摘录。不过明显看得出来，他的功能还是很弱的，过程体，只能是简单的Select/Insert/Update/Create Table|View的单条语句。
PROCEDURE Clause
Defines a name and optional parameters for a query.
Note The PROCEDURE clause has been superseded by the PROCEDURE statement. Although the PROCEDURE clause is still supported, the PROCEDURE statement provides a superset of the capability of the PROCEDURE clause and is the recommended syntax.
Syntax
PROCEDURE name [param1 datatype[, param2 datatype[, ...]]
The PROCEDURE clause has these parts:
| Part | Description |
|---|---|
| name | A name for the procedure. It must follow standard naming conventions. |
| param1, param2 | One or more field names or parameters. For example:
|
| datatype | One of the primary Microsoft Jet SQL data types or their synonyms. |
Remarks
An SQL procedure consists of a PROCEDURE clause (which specifies the name of the procedure), an optional list of parameter definitions, and a single SQL statement. For example, the procedure Get_Part_Number might run a query that retrieves a specified part number.
Notes
- If the clause includes more than one field definition (that is, param-datatype pairs), separate them with commas.
- The PROCEDURE clause must be followed by an SQL statement (for example, a SELECT or UPDATE statement).
See Also
| DELETE Statement | PARAMETERS Declaration |
| EXECUTE Statement | SELECT statement |
| Microsoft Jet Database Engine SQL Data Types | UPDATE statement |