SQL SERVER – Reseed Identity of Table – Table Missing Identity Values – Gap in Identity Column | Jou

Hi Pinal, I’m wondering if we have records like 1,2,3,5,6,8,9… then what? So here is the revised version of the above SQL statements which will insert into middle and at bottom. CREATE TABLE TableID (ID INT IDENTITY(1,1), Col VARCHAR(10)) GO /* Insert 10

blog.sqlauthority.com