Access 存储过程

最新推荐文章于 2025-05-23 12:18:44 发布

转载最新推荐文章于 2025-05-23 12:18:44 发布 · 1k 阅读

文章标签：

#数据库

PROCEDURE Clause

大家看到这个标题第一个反应是什么，估计是“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: `PROCEDURE Sales_By_Country [Beginning Date] DateTime, [Ending Date] DateTime;`
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).