can anybody help me with this

Thanks it worked

I re created table and renoved not null after identity property and inserted values it worked

CREATE TABLE IdentityProducts(

productid int IDENTITY(1,1),

productname nvarchar(40) NOT NULL,

categoryid int NOT NULL,

unitprice money...

http://stackoverflow.com/questions/4871620/how-to-pass-multiple-params-in-batch