If I have an Identity-declared column, the table has lots of rows and I start deleteting records - will any old, deleted identities be re-used (without an explicit re-seed) ?
(I'm talking about numerical Identities, not these GUID things)No. Not without manipulating the IDENTITY column. The exception being that if you TRUNCATE the table, then the seed will reset to the floor value.
Regards,
hmscott|||yeah,it can be used
need to set identity off
insert statement
reset identity on
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment