Cannot insert explicit value for identity column in table 'tblcharge22' when IDENTITY_INSERT is set to OFF.

Question

4.33/5 (2 votes)

See more:

I have got three columns.

When I passed the query like this, it is showing the error:
Cannot insert explicit value for identity column in table 'tblcharge22' when IDENTITY_INSERT is set to OFF.
I am trying to insert into tbltt(srno,txn,ppt) values (1,1,1)

Posted 13-Apr-11 19:42pm

taher ahmed choudhury

Updated 13-Apr-11 21:28pm

Dalek Dave

v2

Add a Solution

Comments

Dalek Dave 14-Apr-11 3:28am

Edited for Grammar and Readability.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Sandeep Mewara · Answer 1 · 2011-04-13T19:46:00

Solution 1

Have a look at these discussions and resolution suggested:
Link 1[^]
Link 2[^]
Link 3[^]

Google[^] has more info in case needed.

Posted 13-Apr-11 19:46pm

Sandeep Mewara

Mahendra.p25 · Answer 2 · 2011-04-13T19:47:00

Solution 3

try this

SQL

SET IDENTITY_INSERT TableName  On
insert into TableName  Values(1,1,1)
SET IDENTITY_INSERT TableName  OFF

Posted 13-Apr-11 19:47pm

Mahendra.p25

Comments

Dalek Dave 14-Apr-11 3:29am

Looks good.

WoutL · Answer 3 · 2011-04-13T20:50:00

Solution 4

Unless you have a verry good reason: don't insert an identity!

So just use:
insert into tbltt(txn,ppt) values (1,1)

Posted 13-Apr-11 20:50pm

WoutL

Comments

Dalek Dave 14-Apr-11 3:29am

Good Answer.

MXZ-RXP 19-Dec-13 20:10pm

thanks! that was the answer-

Costica U · Answer 4 · 2011-04-13T19:46:00

Solution 2

This will fix it

SQL

SET IDENTITY_INSERT tbltt ON
insert into tbltt(srno,txn,ppt) values (1,1,1) 
SET IDENTITY_INSERT tbltt OFF

Posted 13-Apr-11 19:46pm

Costica U

Comments

taher ahmed choudhury 14-Apr-11 1:54am

still showing error

Costica U 14-Apr-11 1:59am

What table do you use "tbltt" or "tblcharge22"?
Because the insert uses "tbltt" but the err message is "tblcharge22".