PROCEDURE Clause

Defines a name and optional parameters for a query.

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;` For more information on parameters, see PARAMETERS.
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).