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

<>

This question already has an answer here:

Answers


When issuing an INSERT statement for a table with an IDENTITY column, don't include the identity column in the fields and values list. For example, the following statement would fail:

INSERT INTO tbl (ID, StudentID) VALUES (1, 1)

but this statement will succeed:

INSERT INTO tbl (StudentID) VALUES (1)

and insert the next available identity value into the ID column.

Now, if you do want to insert an actual identity, do this:

SET IDENTITY_INSERT tbl ON
INSERT INTO tbl (ID, StudentID) VALUES (1, 1)
SET IDENTITY_INSERT tbl OFF

Need Your Help

How to detect if a string contains special characters?

sql sql-server

How to detect if a string contains special characters like #,$,^,&amp;,*,@,! etc in SQL server 2005?

Develop a Chrome extension that overrides SSL certificate exception for a self signed certificate

javascript google-chrome ssl google-chrome-extension

I frequently access a trusted website that uses a self signed certificate. Every time I access it I need to click - through the SSL error page. I know that it is possible to do some manual settings...