So, I’ve been asked to modify some stored procedures. I don’t really know anything about them, so I just right clicked on the existing one and selected “Modify”. I made the changes to the variables and queries that were requested, but since these are supposed to be in addition to the existing procedures rather than actually replacing them, I didn’t run them, I just saved them as queries like I normally do for my boss’ review.
I’m pretty sure that some of the stuff that got inserted at the top should probably go (Such as ALTER PROCEDURE [procedure_name] and there is a folder under the existing folders called Parameters where I will probably want to update the information for the changes to the variables that I made.
Can anyone point me to some good tutorials on stored procedures? I did some searching and came up with these from Technet, but I wanted to make sure they were the best ones to read before I spent a lot of time on them.