PROCEDURE Statement

See Also    Example

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