title: Batch vs SQL statement
body: <p>a)</p>
  
  <blockquote>
    <p>A SQL statement is a single SQL command (for example, SELECT * FROM table1 or SET NOCOUNT ON). A batch on the other hand, is a number of SQL statements sent to the server for execution as a whole unit. The statements in the batch are compiled into a single execution plan. Batches are separated by the GO command</p>
  </blockquote>
  
  <p>So the only difference between SQL statement and a Batch is that each SQL statement is sent to server as a separate unit and thus is compiled separately from other SQL statements, while SQL statements in a Batch are compiled together?</p>
  
  <p>b) I assume one of major differences between a stored procedure and a Batch is that stored procedures are precompiled while Batches aren’t? </p>
  
  <p>thanx</p>