Insert Value into Identity Column Table

Sometimes we want to add value in Identity Column. Mostly when we forget to add Unknown member into dimension table.

Nothing to worry, you can add value to identity column very easily

Set identity_insert TableName on

Insert into TableName (id,data)values(-1000,'Unknown')

SEt identity_insert TableName off