Keld Laursen (VFL) (8/15/2012)
Lokesh Vij (8/15/2012)
Keld Laursen (VFL) (8/15/2012)
It is also worth noting that you have no method of resetting the identity counter for the table.Thanks for the question. I were fairly sure that I had it right before submitting, but the other choices listed had me re-check. And I were right 🙂
Very rightly pointed out Keld. Truncate resets the identity counter for the table..
Which were my point exactly: No truncate, no reset. Other DML to reset the counter will also fail.
I was just trying to re-iterate, as Table variable does not allow truncate to be used, identity counters will not reset 🙂
~ Lokesh Vij
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter