Posts Tagged ‘MSSQL’

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 [...]