定义存储过程语法:
create proc procedure_name[;number]
@parameter_name data_type [output][=default]
...
as
sql_statements
调用存储过程语法:
exec [@return_value=]procedure_name[;number] [@parameter_name=value] [@parameter_name=@variable_name output]
insert into table_name exec procedure_name
删除存储过程语法:
drop proc procedure_name