title: Let SQL wait until previous statement is done
body: <p>I have been searching around but I cannot find the correct answer, probably I search wrong because I don't know what to look for :)</p>
  
  <p>Anyway, I have a TSQL with a <code>begin</code> and <code>commit transaction</code>. In the transaction I add some columns and also rename some columns.
  Just after the renames and added column statement i also run some update statements to load data into the newly created columns.</p>
  
  <p>Now the problem is that for some reason the update gives an error that it cannot update the given column as it does not exist (YET???).</p>
  
  <p>My idea is that the statement is still working out the rename and the adding of the columns but already goes ahead with the update statements. The table is very big and has a few million records so I can imagine it takes some time to add and rename the columns</p>
  
  <p>If I run first the rename and add statements and than separate the update statements, it does work. So it has to do with some wait time.</p>
  
  <p>Is it possible to make sql force to execute step by step and wait until the complete statement is done before going to the next? </p>