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

If you’re using Visual Studio to build your .NET MAUI app on a Mac, locating the IPA (iOS App Package) file can be a bit tricky

  If you’re using   Visual Studio   to build your   .NET MAUI   app on a   Mac , locating the   IPA (iOS App Package)   file can be a bit tr...