Post reply

can we insert record with deleted row identity number

  • August 8, 2014 at 5:39 am

    #310556

    Hi,

    i have table with fields id,name,address here id is identity column first i inserted five rows ,after that i deleted id=3 row now i want to insert record with id=3 is it possible without stop identity on column.

    Thank you.

    --chalam

  • August 8, 2014 at 5:48 am

    #1736377

    Yes, it is, using IDENTITY_INSERT, but why would you want to? The values in the ID column don't (or shouldn't) have any intrinsic meaning, so it doesn't matter if any numbers are skipped.

    John

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply