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.
asked
Row number
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.
