Advertiser Disclosure

Download our iPhone app

TODAY'S HEADLINES | ARTICLE ARCHIVE | FORUMS | TIP BANK

Specialized Dev Zones

Research Center

eBook Library

.NET

Java

C++

Web Dev

Architecture

Database

Security

Open Source

Enterprise

Mobile

Special Reports

10-Minute Solutions

DevXtra Blogs

Slideshow

Python Wonderwords Library: Random Words and Sentences

How to Split Strings in Java

Python Logical Operators

How to Use the StringJoiner Class in Java

How to Find the Status of Threads in Java

SQLServer - insert IDENTITY

Before inserting IDENTITY values in SQLServer you have to turn on IDENTITY_INSERT.

by Octavia Andreea Anghel

Apr 2, 2021

Before inserting IDENTITY values in SQLServer you have to turn on IDENTITY_INSERT as here:

SET IDENTITY_INSERT [foo_table] ON
INSERT INTO foo_table (...) VALUES (...)
...
SET IDENTITY_INSERT [foo_table] OFF

Thanks for your registration, follow us on our social networks to keep up-to-date