Microsoft SQL Sample Code

SQL for Inserting a value Into an Identity field

This sql script is very useful for inserting a value directly into an identity field in your sql server table. By default, an identity field in a SQL server table auto increments it's value. You may have a need to insert an explicit value into the Identity field, but find that you can't do that. The code below will show you how to accomplish that.

SET IDENTITY_INSERT dbo.YourTableName ON; Insert Into YourTableName (YourIdentifyField) Value (0); SET IDENTITY_INSERT dbo.YourTableName OFF;

If you need any help implementing this sql or modifications made for your needs, please Click Here to get a free quote for your Microsoft SQL Development needs. 

Click Here to learn more about the WSI quoting process.