I am new to SQL, using 2014 Developer Edition
Since we are still working exclusively with the developement DB I have not run into this situation but I'm wondering how it will work when I do.
I wondering how to move new or changed, non-table objects from a test SQL DB to the production DB.
In our in-house development environment of the SQL DB we create and test a new stored procedure 'spNew' to handle a lookup in the production DB. How do we move just 'spNew' to the production SQL DB?