title: Inserting a row in identity column of table variable
body: <p>I have the following table variable:</p>
  
  <pre><code>declare @TestTable2 as table (A int identity)
  </code></pre>
  
  <p>I'm trying to insert some value (for instance a 1) <strong>without altering the line of code above</strong>.</p>
  
  <p>I've been trying to do the following</p>
  
  <pre><code>declare @TestTable2 as table (A int identity)
  
  
  
  SET IDENTITY_INSERT @TestTable2 ON
  INSERT @TestTable2 (A)
  VALUES (1)
  </code></pre>
  
  <p>But I get an error (Incorret syntax near '@TableTEST2')</p>
  
  <p>How can I insert a value in the column <code>A</code>?</p>