title: The best practice for creating a stored procedure in sql
body: <p>I had this problem once, creating a procedure and then when I want to alter it I used to drop it first then re-create it again. Then I thought that was taking a lot of time.
  I had to find a better way!</p>
  
  <p>which is the best way, to ease the time. and also incase you need to Alter it later??</p>