I tried inserting values into a table and when I executed, it did not show me that a row was affected… so I ran it again. Then when I did select * from table, it showed me that it was entered twice. I tried deleting by the GUI method of right click, edit top 200 rows, but it does not let me delete it saying that 2 rows are affected or something. HOW can I delete the duplicate row and still keep one? It is really annoying.
you can see in the photo for addressID 6 and 7 they are both repeated twice. thank you!