Scenario Based Questions

Suppose you have the table having identity column.

You delete the last row from the table which having identity value suppose 10 and then insert a new row in table. The new identity value which will get inserted in the table will be the next value i.e. 11.

So the question is that from where sql server reads the old identity value 10 (as data already deleted) and generates the new identity 11 accordingly to insert into table

SQL Server interview Questions and Answers

http://sqlserverquest.blogspot.com