parmar.randheer11 (2/3/2011)
How sql server retrieves the next identity value for delete command used in table as deleted rows are moved to log.i just want to understand the actual process.
I don't really see what IDENTITY has to do with the DELETE command, except that it can create gaps in your sequence.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP