sqlserver的存储过程

1.无参的存储过程

--创建
create procedure sys_test_process02
as
begin
    sql语句
end

--执行
EXEC sys_test_process02

2.带参存储过程

--创建
CREATE PROCEDURE sys_test_process
    @parameter1 nvarchar(50),
    @parameter2 nvarchar(50)
AS
BEGIN
   	SELECT * FROM 表名 where 列名= @parameter1;
    sql语句;
END

--调用
EXEC sys_test_process03 "12313","123";
EXEC sys_test_process @parameter1="12313",@parameter2="123";

3.带输出参数的存储过程

--创建
create procedure sys_test_process05
	@recordCount int output
as
begin
    set @recordCount = (SELECT count(*) from sys_test)
end

--调用
declare @num int
EXEC sys_test_process05  @recordCount=@num output;
select * from sys_test st where test_id > @num;