title: Incorrect syntax in table variable insert via select
body: <p>I can't figure out what in the world this is complaining about, looks fine to me:</p>
  
  <pre><code>DECLARE @newidentity int 
  SET @newidentity = scope_identity()
  select @newidentity
  
  Insert into @Companies (select @newidentity, Name from Company where Name = 'Parker')
  </code></pre>
  
  <p>I get the following for the insert line:</p>
  
  <blockquote>
    <p>Incorrect syntax near the keyword 'select'.<br>
    Incorrect syntax near ')'.</p>
  </blockquote>