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:
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