How does a stored procedure return values

Question

Hi friends How does a stored procedure return values?

Grabsi Amine · Answer

Structure Stored procedures are extremely similar to the constructs seen in other programming languages. They accept data in the form of input parameters that are specified at execution time. These input parameters (if implemented) are utilized in the execution of a series of statements that produce some result. This result is returned to the calling environment through the use of a recordset output parameters and a return code. That may sound like a mouthful but you'll find that stored procedures are actually quite simple. Example Let's take a look at a practical example. Assume we have the table shown at the bottom of this page named Inventory. This information is updated in real-time and warehouse managers are constantly checking the levels of products stored at their warehouse and available for shipment. In the past each manager would run queries similar to the following: SELECT Product Quantity FROM Inventory WHERE Warehouse = 'FL'