====== SET IDENTITY ======
  * Allows explicit values to be inserted into the column with the identity property.

<code sql>

SET IDENTITY_INSERT SomeTable OFF
GO

INSERT INTO SomeTable(IdentityColumn) VALUES(1)

GO
SET IDENTITY_INSERT SomeTable  OFF

</code>