title: Creating Stored Procedure Syntax, relating to use of GO
body: <p>Does anyone know why.</p>
  
  <pre><code>CREATE PROCEDURE My_Procedure
      (@Company varchar(50))  
  AS  
      SELECT PRD_DATE 
      FROM WM_PROPERTY_DATES 
      WITH (NOLOCK) 
      WHERE PRD_COMPANY = @Company 
  GO
  </code></pre>
  
  <p>Gives me an error message in SQL management studio:</p>
  
  <blockquote>
    <p><code>Msg 102, Level 15, State 1, Procedure My_Procedure, Line 1
    Incorrect syntax near 'GO'.</code></p>
  </blockquote>
  
  <p>Now, this is the last statement of a batch, maybe the last statement should not have a <code>GO</code> ?</p>