How to update identity column in SQL
There are times when we required identity columns values to updated as per the application logic and flow. But how can update the identity column. Let us see below how we can achieve this. We have to use IDENTITY_INSERT which allows explicit…