In what way an identity field differentiates the delete and truncate command?
With TRUNCATE, If the table contains an identity column, the counter for that column is reset to the seed value defined for the column. If no seed was defined, the default value 1 is used. To retain the identity counter, use DELETE instead.
SQL Server Interview Questions · · · ·