Let's say i have the following stored procedure, which return results using "SELECT" instead of RETURN. I use the following codes to get results from my stored procedure :- If you're trying to get value from a stored procedure which give back result using "return", you can use this piece of code. That's it! :)