shad.saleem41 (10/4/2013)
HiI created a table
CREATE TABLE IdentityProducts(
productid int IDENTITY(1,1) NOT NULL,
productname nvarchar(40) NOT NULL,
categoryid int NOT NULL,
unitprice money NOT NULL)
I want to insert values into it with the belkow statement
insert into IdentityProducts(productname,categoryid,unitprice)
values
('shad',1,100)
when i insert the "productid" should get inserted automatically as it is defined with identity propert
but its not happening
even though i have made
SET IDENTITY_INSERT IdentityProducts ON
I am getting the following error
============
Msg 545, Level 16, State 1, Line 1
Explicit value must be specified for identity column in table 'IdentityProducts' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.
==============
:crying:
If you turn IDENTITY_INSERT on for a table, SQL Server is expecting you to provide the values for that column rather than having the values generated automatically. As stated above, turn IDENTITY_INSERT off and try your code again.