Microsoft Logo

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.

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.

About Us

WSI is a small business and a leading provider of custom SQL Server/Azure programming and database solutions for government entities, Fortune 1000 companies, and emerging businesses. We are your custom SQL Server/Azure development experts.