CREATE PROC [ EDURE ]
procedure_name [
;
number ]
[ { @ parameter data_type }
[ VARYING ] [ = default ] [ OUTPUT ]
] [ ,... n ]
[ WITH
{ RECOMPILE | ENCRYPTION | RECOMPILE , ENCRYPTION } ]
[ FOR REPLICATION ]
AS sql_statement [ ... n ]
[ { @ parameter data_type }
[ VARYING ] [ = default ] [ OUTPUT ]
] [ ,... n ]
[ WITH
{ RECOMPILE | ENCRYPTION | RECOMPILE , ENCRYPTION } ]
[ FOR REPLICATION ]
AS sql_statement [ ... n ]