Insertion problem - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Insertion problem

omaragainontheomaragainonthe Posts: 1Member
I have set the EMP_ID column in my database as the Primary Key. I mean it has primary key on this column. And when I try to insert values in my database table from the form in then it gives me an error as:

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

So, how is the IDENTITY_INSERT set to on. Where it is actually located so that I can modify it and start to insert values into my table.

Moreover, when I remove the primary key from this column(EMP_ID) and uncheck the Allow Nulls checkbox then also my same problem persists.

Kindly help me out.

Comments

Sign In or Register to comment.