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

Using Add() and Remove() ArrayList Methods in Java

How to Use Java ArrayList

Python Comparison Operators

Using Java Comparison Operators

How to Create the Hello World Program 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