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

How to upload app to macOS

1. Open Terminal Press Cmd (⌘) + Space , type Terminal , and hit Enter . 2. Navigate to Your Build Output Directory Your .app file is likel...