If you are developing code then you are advised to use a source control system. Aside from not having the copy of the release code reside on your machine or the machine of whomever created the stored procedure in this particular case, a good practice, source control systems can alert you to problems with your script before deploying anywhere. Such is the case when you select a column that does not yet exist.