SQL: Explicitly Setting IDENTITY Key Value using IDENTITY_INSERT
You may come across a need to explicitly set an IDENTITY Key value in your insert statement. I recently came across this need when I wanted to add some columns to a Dimension table to account for any NULL values I was transforming. Take into account my DimDates table: CREATE TABLE [dbo].[DimDates]( [DateKey]…