Store Procedures with output parameter

use AdventureWorks

 

Create Proc test 

( 

@EmployeeID int, 

@ManagerID int output 

) 

as begin 

select @ManagerID=ManagerID from HumanResources.Employee 

where EmployeeID=@EmployeeID 

End 

Declare @output int

Exec test 2,@managerID=@output output

print @output