title: adding a column in stored procedure
body: <p>Can I have one single stored procedure to add a new column to a table and work on the column afterwords? For example, I have following stored procedure:</p>
  
  <pre><code>...
  
  alter table tb1
  add col1 varchar(1) null
  
  insert into tb1(col1)
  values ('Y')
  </code></pre>
  
  <p>I got an error saying </p>
  
  <blockquote>
    <p>col1 is invalid.</p>
  </blockquote>