The complete syntax for create procedure is:
create procedure [owner.]procedure_name[;number]
[[(]@parameter_name
datatype [(length) | (precision [, scale ])]
[= default] [output]
[, @parameter_name
datatype [(length) | (precision [, scale])]
[= default] [output]]...[)]]
[with recompile]
as {SQL_statements | external name dll_name}
You can create a procedure in the current database only.
Permission to issue create procedure defaults to the Database Owner, who can transfer it to other users.
Here is the complete syntax statement for execute:
[exec[ute]] [@return_status = ] [[[server .]database.]owner.]procedure_name[ ;number] [[@parameter_name =] value | [@parameter_name =] @variable [output] [, [@parameter_name =] value | [@parameter_name =] @variable [output]...]] [with recompile]
