below86 (2/27/2014)
I have often said I avoid stored procedures for the most part. But this too has always seemed odd to me. You are essentially replacing the entire code when you do the ALTER PROCEDURE, so why not drop the procedure and do a create?
because you lose the permissions granted to the stored proc that way.
Why do you avoid stored procedures?
---------------------------------------------------------------------