title: alter table then update in single statement
body: <p>I have a requirement where I need to Alter (Add 2 columns) and then update the same table.</p>
  
  <p>Here is the query I tried:</p>
  
  <pre><code>ALTER TABLE A
  ADD c1 int,c2 varchar(10)
  
  UPDATE  A set c1 = 23, c2 = 'ZZXX'
  </code></pre>
  
  <p>I need to run the above two queries at a time.</p>
  
  <p>I am using Talend ETL tool, in this we have a component tMssqlrow, which allow us to run multiple queries (I am using 10 to 15 update queries in single component).</p>
  
  <p>But the above query is not working.</p>
  
  <p>I tested in DataBase Microsoft SQL. i am getting the below error :</p>
  
  <blockquote>
    <p>Msg 207, Level 16, State 1, Line 5 </p>
    
    <p>Invalid column name 'c1'. Msg 207,</p>
    
    <p>Level 16, State 1, Line 5 </p>
    
    <p>Invalid column name 'c2'.</p>
  </blockquote>
  
  <p>can any one help me resolve this problem.</p>