Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Duplicate Error

Author  Topic 

sunny_10
Yak Posting Veteran

72 Posts

Posted - 2014-03-04 : 01:24:03
Hi

I have defined 1 field as Primary Key Data Type is text . I have 1 record already value is 03041201, when i try to save second record it gives me the below error :-

Violation of Primary Key constraint 'PK_Transact_1' . Cannot insert duplicate key in object dbo.temp

though value of primary key is 03041202

Thanks

sunny_10
Yak Posting Veteran

72 Posts

Posted - 2014-03-04 : 01:29:51
closed
Go to Top of Page
   

- Advertisement -