posts - 0, comments - 1573, trackbacks - 0

August 2010 Blog Posts

The row value(s) updated or deleted either do not make the row unique or they alter multiple rows.

I had a user ask me today how they can delete a duplicate row from their database table. They were receiving the following error message when they tried to delete the duplicate row. The row value(s) updated or deleted either do not make the row unique or they alter multiple rows. The reason that the user gets this message is because the table did not have a Primary Key or other Unique Index defined. Why, that’s another story and not one I know! An example table Some example data ...

posted @ Monday, August 30, 2010 6:55 PM | Feedback (0) |

Powered by:
Powered By Subtext Powered By ASP.NET