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

Delete Duplicate Rows from SQL Database Without a Primary Key

Written by Mostafa Dafer on . Posted in Tips & Tricks

Just wanted to share with you a simple trick for deleting a duplicate row in your SQL table when you haven't assigned a primary key. So you may be wondering how could this happen... Well, in most cases, it would happen when you are setting an Id to your item by hand instead of using Identity to automatically set the Id. This leads us to another question, which is why would we set the Id by hand? Now here comes several answers, the best is the case where we need to insert a new item to the table Read more [...]

Like Us!

Subscribe to newsletter!

Enter Your Email: