Follow me on :
We have the table 'temp' with columns 'id' and 'name'. We are having values in it is
Now, we want to add the value in b/w 2 and 4 i.e. 3, then use the following method to do so...
set identity_insert temp on
insert into temp(id,name) values (3,'C')
set identity_insert temp off
Now, if you see the result, then it could be...
Now onwards, it will behave like an identity column, if you further insert any row in it.
Login to post response