title: How should I declare auto increment variable in the virtual table of stored procedure
body: <p>I have a stored procedure like this</p>
  
  <pre><code>create procedure onedata
  
  as
  
  begin
  
  declare @input_data table (Id int NOT NULL AUTO_INCREMENT, name varchar(500) . .... )
  
  insert into @input_data .....
  ....
  
  end
  </code></pre>
  
  <p>But i am not able to declare Id to be <strong>AUTO_INCREMENT</strong>.It showing some error.<br>Please suggest some solution.</p>
  
  <p>Thanks in advance</p>