Friday, March 9, 2012
Identity Increment
If delete all the records from a table that has an incremental identity. Is there a TSQL way of reset the first number on an insert back to be 1 again without going to the table taking it off then saving it the putting it back on again?TRUNCATE table clears all data and resets the Identity counter.|||Perfect! Thank you.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment