Click here to Skip to main content
15,891,943 members
Search within:


How to insert value in identity column without set to off
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
SQL-Server-2008R2
Dear All,

I have a table with identity column and I want to add value without set identity off.
Posted
Add a Solution
Comments
John C Rayan 28-Apr-15 8:19am    
Can you explain why you want to do this? What you are trying to do is not right. If you have identity column then why you want to override? You need to look at your table design.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
How to insert value into identity column..?
Identity specification column skipping values
Cannot insert explicit value for identity column in table 'tblcharge22' when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table 'OS_Mailinglist1' when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column in table 'bill' when IDENTITY_INSERT is set to OFF.
How do I resolve the error sqlexception: cannot insert explicit value for identity column in table 'tblalltransactionswithdetails' when IDENTITY_INSERT is set to OFF.
Cannot insert explicit value for identity column" even when I SET IDENTITY_INSERT on
Cannot insert explicit value for identity column
An explicit value for the identity column in table
Error during update-database in code first migration. - "Cannot insert explicit value for identity column in table 'table name' when IDENTITY_INSERT is set to OFF."

Advertise
Privacy
Cookies
Terms of Use
Last Updated 23 Apr 2015
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web01 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900