Creates a stored procedure.
Note: The Microsoft Access database engine does not support the use of CREATE PROCEDURE, or any of the DDL statements, with non-Microsoft Access database engine databases.
Syntax
CREATE PROCEDURE procedure (param1 datatype[, param2 datatype][, ...]) AS sqlstatement
The CREATE PROCEDURE statement has these parts:
|
Part |
Description |
|
procedure |
A name for the procedure. |
|
param1, param2 |
From one to 255 field names or parameters. |
|
datatype |
One of the primary Microsoft Access SQL Data Types or their synonyms. |
|
sqlstatement |
An SQL statement such as SELECT, UPDATE, DELETE, INSERT, CREATE TABLE, DROP TABLE, and so on. |
Example
CREATE PROCEDURE Sales_By_CountryRegion ([Beginning Date] DateTime, [Ending Date] DateTime) AS SELECT Customer, [Ship Address] WHERE [Shipped Date] Between [Beginning Date] And [Ending Date]
Remarks
An SQL procedure consists of a PROCEDURE clause that specifies the name of the procedure, an optional list of parameter definitions, and a single SQL statement.
A procedure name cannot be the same as the name of an existing table.
