"We have been very pleased with the competent, prompt and courteous service they have provided to us."

Stu Perlman
Monarch/USESI (New Jersey)
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.

Iowa Headquarters
(MIDWEST)
301 Alexander Ave., Suite C
P.O. Box 726
Ames, Iowa 50010
Tel: (515) 239-9900
Fax: (515) 239-9800

Driving Directions to the Ames Iowa Headquarters
Minnesota Headquarters
(Upper Midwest)
119 Washington Avenue N, 2nd Floor
Minneapolis, MN 55401
Tel: (612) 286-0675
Florida Headquarters
(Southeast)
4200 Evans Ave., Suite 10
Fort Myers, Florida 33901
Tel: (239) 267-2749
Fax: (239) 267-9936
Caribbean & Latin America
(Puerto Rico)
Tel: (787) 303-0042
South Dakota - Sioux Falls
Tel: (605) 496-9580
Texas - Austin
Tel: (512) 593-1056
New Mexico - Albuquerque
Tel: (505) 289-1364
IOWA/ILLINOIS - QUAD CITIES/MUSCATINE
Tel: (563) 316-2378
Want quick Answers?
During normal business hours you can reach us via our live chat program.  Try it, it's really cool!!
 
Partner Locations
Quad Cities, Iowa
Cedar Rapids, Iowa
 
Interested in joining our partner program?  Click Here to learn more about the Winning Solutions, Inc. Partner Program.
Disclaimer
Winning Solutions Inc. is an independent service provider for THIRD PARTY PRODUCTS where WSI provides support on remote, chat and over the phone basis for issues related to computer software. All other trademarks, registered trademarks, company names, product names and brand names for the third party trademarks are the property of their respective owners, and WSI disclaims any ownership , right , affiliation or endorsement of or by any such third party. The use of any third party trademarks, logos or brand names is for informational purposes only.