we have a rownumber to a specific column and if i have done truncate to the table and again inserting records will it continue the sequence or it will start from 0 again.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
If you mean you use the IDENTITY property of a column to generate unique IDs, then yes after a TRUNCATE the identity counter will be reset to the seed value that is defined on the column. If no seed was defined, then it will start at 1.
16 People are following this question.
DIFFERENCE OF DELETE AND TRUNCATE
Truncate the Log
Best way to refresh an entire database daily?
ssis is automatically truncating strings
delete and truncate in log shipping