563 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Output Parameters and Return Codes in SQL Server Part one of a three-part series of blogs |
---|
This blog teaches you how to return values from your SQL stored procedures using two different techniques: return codes, and output parameters.
This blog is part of a complete SQL tutorial. You can learn about the techniques used in this blog on our Advanced SQL training course. |
There are two techniques for returning values from a stored procedure: using return codes, and using output parameters. The main differences between these techniques are described in the table below:
Technique | Description |
---|---|
Return code | A stored procedure can return a single value using a return code. The data type of the value must be an integer (a whole number). |
Output parameter | A stored procedure can have many output parameters. An output parameter can use any data type. |
Output parameters are more flexible than return codes but they are a little more fiddly to use. The rest of this blog series will show you how to use each of these techniques, starting with return codes.
Parts of this blog |
---|
|
Some other pages relevant to the above blogs include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2023. All Rights Reserved.