954,525 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Error while deleting records from table

Table Name => PropDocument
Column1 => propertyid ( foreign key from Property table )
Column2 => documentid ( foreign key from Document table )

The error ( in the attached image ) comes when
I try to delete the record.
This error comes often when there are 2 records with same values as you can see in the image.

By mistake I have added that records but
now how can I delete the records ?

Attachments ErrorWhileDeleting.jpg 91.92KB
Nitin Daphale
Junior Poster in Training
64 posts since Apr 2010
Reputation Points: 10
Solved Threads: 0
 
ALTER TABLE Table1

ADD TempID int IDENTITY(1, 1)


Run this in SQLBrowser

It will create another Column and make everything unique

Delete what you want and then delete the column

finito
Nearly a Posting Virtuoso
1,321 posts since May 2010
Reputation Points: 60
Solved Threads: 135
 

Thanks finito
It worked .

Nitin Daphale
Junior Poster in Training
64 posts since Apr 2010
Reputation Points: 10
Solved Threads: 0
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: