One can create the stored procedure and store it in an .sql file which can be version controlled like any piece of code. These can then be deployed in a number

One can create the stored procedure and store it in an .sql file which can be version controlled like any piece of code. These can then be deployed in a number of ways.