Gud question. I had forgotten abt incremental value as I never use it. I always increment identity column with default value.