Thursday, July 7, 2011

How to retrieve return value of stored procedure in Query Analyzer

Following lines of code explains how to retrieve return value of stored procedure from Query Analyzer

Here I am assuming that our sp is called:usp_SelTest

declare @i int

exec @i =usp_SelTest @Parameter1 = 1
select @i as 'return value'

No comments:

Post a Comment

Your project is not referencing the "MonoAndroid,Version=v8.1" framework. Add a reference to "MonoAndroid,Version=v8.1" in the "frameworks" section of your project.json, and then re-run NuGet restore.

I had  the same problem. Reason: file obj/project.assets.json target "MonoAndroid,Version=v7.1" when my project target androi...