title: Is there anyway to reset the identity of a Table Variable?
body: <p>Say I have a table variable:</p>
  
  <pre><code>DECLARE @MyTableVar TABLE (ID INT IDENTITY(1,1), SomeData NVARCHAR(300))
  </code></pre>
  
  <p>After I have inserted 250 rows, I need to "Start Over" with the table.  I do this:</p>
  
  <pre><code>DELETE FROM @MyTableVar
  </code></pre>
  
  <p>Is there anything I can do to the table variable so that this:</p>
  
  <pre><code>insert into @MyTableVar Values("TestData")
  select * from @MyTableVar
  </code></pre>
  
  <p>will return this:</p>
  
  <pre>
  _______________________________
  |    ID     |    SomeData     |
  |___________|_________________|
  |           |                 |   
  |     1     |    TestData     |        
  |___________|_________________|</pre>
  
  <p>instead of this:</p>
  
  <pre>
  _______________________________
  |    ID     |    SomeData     |
  |___________|_________________|
  |           |                 |   
  |    251    |    TestData     |        
  |___________|_________________|</pre>