SQL Server存储过程，StoreProcedure

----创建存储过程
create proc[edure] 存储过程名
[
{@参数1 参数类型}[=默认值][output],
......,
{@参数n 参数类型}[=默认值][output],
]
as
SQL 语句块

----执行存储过程
exec/execute 存储过程名

----带参数的简单存储过程实例

create proc p_Employee
 @count int output
as
 print 'Records number:'
 Select count(*) From dbo.Employee
 print @count
go

declare @sumcount int
exec p_Employee @sumcount
go

转载于:https://www.cnblogs.com/eva_2010/articles/2049876.html