A simple example of creating a stored procedure that allows for two input values and returns a query result with a range between those two values. This example is using MySQL and the Northwinds Database as a practice, but has practical applications for a wide range of data sets when a range of data is desired.
This particular example is using OrderID as the input fields, but is also querying ProductID, UnitPrice, and Quantity when the OrderID range is specified.
-
Notifications
You must be signed in to change notification settings - Fork 0
skyblasy/SQL-stored-procedure-with-ranged-input-values
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
About
An example of creating a stored procedure that takes two input values and returns a range between those values.
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published