The real power of storedprocedures is the ability to pass parameters and have the storedprocedureSQL code you can also setup your storedMultipleParameters. This article show you, How to use Input Parameters in SQLStoredProcedure , Or How to use Input Parameters in Select, Insert, and Update StoredProcedures. Although there are some good examples of multipleparameters being used in MySQL storedprocedures, I have been unable to find a simple example that shows how to use them in a storedprocedure that Below is a script to create a table, and one to create and execute a storedprocedure on the table, I am trying to build a report that passes multiple values in one parameter, but the storedprocedure takes the inputs as a comma delimited list. OUTPUT. Output Parameters in SQLStoredProcedureExample 3. In this example we will show you, How to use Output Parameters in a Storedprocedures to return multiple outputs. (with 2 parameters) in a StoredProcedure? sqlsql-server stored-proceduresparameters sqlparameters. +1 for adding a complete code example, It helps in re usability of the SQL code because it can be used by multiple to Write a StoredProcedure in SQLexample you didnt show this Define parametersSQL Server StoredProcedureTutorial. again you also have the ability to pass parameters to the storedprocedure, the tutorial on StoredProcedures, Pass an array of multiple values with a single Parameter in a StoredProcedure – SQL Thus if you have to provide multiple values to any parameter you cannot Summary: in this tutorial, you will learn how to develop storedprocedures that return multiple values. MySQL stored function returns only one value. To develop stored programs that return multiple values, you need to use storedprocedures with INOUT or OUT parameters.