Home Forums Article Discussions Article Discussions by Author Discuss content posted by Clare Newman Table Variable RE: Table Variable

  • August 15, 2012 at 11:56 pm

    #1526340

    Lokesh Vij (8/15/2012)

    Keld Laursen (VFL) (8/15/2012)

    It is also worth noting that you have no method of resetting the identity counter for the table.

    Thanks for the question. I were fairly sure that I had it right before submitting, but the other choices listed had me re-check. And I were right 🙂

    Very rightly pointed out Keld. Truncate resets the identity counter for the table..

    Which were my point exactly: No truncate, no reset. Other DML to reset the counter will also fail.