Answer : 10
Explanation: The identity column can be omitted when using and INSERT that doesn't specify a column list. So, you won't get an error. According to BOL, "If the table contains an identity column, the counter for that column is reset to the seed value defined for the column when you TRUNCATE the table. If no seed was defined, the default value 1 is used. To retain the identity counter, use DELETE instead."
Source: From SQLServerCenteral.Com (Original Author : Dun) | |