SQL Server Programming Part 4 - Output Parameters & Return Values
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andrew Gould
https://www.wiseowl.co.uk - Output parameters and return values are two methods in SQL for getting information out of a stored procedure. This video teaches you how to use both methods, including how to define output parameters and set their values within a procedure, how to add a return statement to a stored procedure, and how to capture the output of a procedure when you execute it.
You can download the script to create the Movies database used in this video at the following link:
https://www.wiseowl.co.uk/files/execi...
You can see the range of resources and courses we offer in SQL Server here:
https://www.wiseowl.co.uk/sql/
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!