How to Test Stored Procedure which has OUTPUT Parameter as an argument?
you have created on SP which takes bunch of args and one of it is OUTPUT parameter which gives ID of last inserted record.. you want to test it using Management studio how can you do it??
Here is the steps :
DECLARE @givemebackID bigint –it can be your parameter name[not compulsory]
exec usp_AddEmployee ‘ABC’,’USA’,@givemebackID= @givemebackID OUTPUT
Execute it and enjoy!!!