How to return the output of stored procedure into a variable in sql server

user_508377 0
Viewed 284247

I want to execute a stored procedure in SQL Server and assign the output to a variable (it returns a single value) ?

stored-procedures sql-server sql variables
4 Answers

With the Return statement from the proc, I needed to assign the temp variable and pass it to another stored procedure. The value was getting assigned fine but when passing it as a parameter, it lost the value. I had to create a temp table and set the variable from the table (SQL 2008)

From this: 
declare @anID int
exec @anID = dbo.StoredProc_Fetch @ID, @anotherID, @finalID
exec dbo.ADifferentStoredProc @anID (no value here)

To this:
declare @t table(id int) 
declare @anID int
insert into @t exec dbo.StoredProc_Fetch @ID, @anotherID, @finalID
set @anID= (select Top 1 * from @t)
user_33815120
Related