[본문스크랩] mssql 저장프로시저 예문

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