Insert Values into IDENTITY column using IDENTITY_INSERT in SQL Server

One of main purpose of the IDENTITY column is used to uniquey identify each row uniquely. Normally i dont recomend to manually edit the Identity column but some times we have to do it. So in this article i would like show you how to insert values into IDENTITY column.