Open

Advice on how to set up an environment for Stored Procedures

I am learning to write stored procedures. What is best practice for where to store / save them until they are ready to be used in production? I don't want to add them to a huge list of existing stored procedures on the database I will be writing them for. Should I create a sandbox database and create them there, using the tables from the production database?