Originally Posted by blaaskaak
It's not the key I'm worried about, it's double entries smile


And double entries it is. Because it has no key, it has no way of knowing whether to add or to replace. On this table, the result with insert into and replace into gives the same result.


[Linked Image from siemons.org]