• easy ...truncate resets the identity;

    It's a coincidence , I was just discussing it with my colleague about inserting a row in between identity inserted column. And yes, Truncate popped up as an option 🙂

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm: