SQL Server——存储过程
创建存储过程语法
CREATE PROCEDURE procedure_name
{
@parameter data_type
}
[VARYING][=default][OUTPUT]
AS
[RECOMPILE|ENCRYPTION|RECOMPILE,ENCRYPTION]
sql_statement
创建存储过程语法
CREATE PROCEDURE procedure_name
{
@parameter data_type
}
[VARYING][=default][OUTPUT]
AS
[RECOMPILE|ENCRYPTION|RECOMPILE,ENCRYPTION]
sql_statement