title: Is GO required before and after SET IDENTITY_INSERT to ON/OFF
body: <p>Do I need GO before and after SET IDENTITY_INSERT to ON/OFF?</p>
  
  <p>I see a lot of samples, articles use this, but when I skip GO, the script works fine.</p>
  
  <pre><code>GO
  SET IDENTITY_INSERT [PropertyValue] ON
  GO
  
  -- Some script
  
  GO
  SET IDENTITY_INSERT [PropertyValue] OFF
  GO
  </code></pre>
  
  <p>I wonder if this is a good code conversion.</p>