shad.saleem41 (10/4/2013)

---

Hi

I 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: