mssql 저장프로시저 예문

하루에도 열두번씩 | 챨스
http://blog.naver.com/khm8843/20033529213

use Northwind

-- 프로시저 예제
--생성
create Procedure dbo.test_procedere01
As
Begin
select top 3 * from Categories
end

--실행
exec test_procedere01

--생성
create Procedure dbo.test_procedure02
@CategoryID int
As
Begin
select * from  Categories where CategoryID = @CategoryID
end
--실행
exec  test_procedure02 '1'

--생성
create Procedure dbo.test_procedure03
As
Begin

Declare @cnt int
select @cnt = count(*) from Categories
return @cnt

end
--실행
declare @cnt int
exec @cnt = test_procedure03
select @cnt

--생성
create procedure dbo.test_procedure04
@cnt int output
as
begin
select @cnt = count(*) from Categories
end

declare @cnt int
exec test_procedure04 @cnt output
select @cnt