Mega Code Archive
CREATE PROCEDURE Syntax
The basic syntax for creating a stored procedure looks like this:
CREATE PROCEDURE procedure_name
[ { @parameter data_type }[ OUTPUT ]
] [ ,...n ]
[ WITH
{ RECOMPILE | ENCRYPTION } ]
AS sql_statement [ ...n ] >