Good morning gentlemen, I am removing the price from the box in BILLING DB and giving the following error.
Msg 2627, Level 14, State 1, Line 1Violation of PRIMARY KEY constraint 'PK_tbl_cashList'. Cannot insert duplicate key in object 'dbo.tbl_cashList'.The statement has been terminated.
I'm using the command
INSERT INTO dbo.tbl_cashList (id, name, cost) VALUES ('524','cash525',2900)
Msg 2627, Level 14, State 1, Line 1Violation of PRIMARY KEY constraint 'PK_tbl_cashList'. Cannot insert duplicate key in object 'dbo.tbl_cashList'.The statement has been terminated.
I'm using the command
INSERT INTO dbo.tbl_cashList (id, name, cost) VALUES ('524','cash525',2900)