No one has asked the obvious question: "How did the duplicates get there in the first place?"

Usually, when duplicates show up, it is due to some upstream error and/or a...

TIAT!

(the Ts stand for Tempest and Teapot, respectively)

I agree with Chris on E/R Studio.  I have used Power Designer, Erwin, and E/R Studio, the three that usually make it to the top of any evaluation list.  Of...

I believe this is a PL/SQL feature that never made it to SQL Server (any version).

See http://www.answers.com/topic/upsert

The following excerpt explains how it really is in 99% of the cases.

"the ontology-mapping table may be generated in either a semi-automated way or a totally automated way.  In the...

This looks like an attempt to do a DELETE CASCADE on employee, where the employee's ID (the 100 in the example) appears as a foreign key value in the department...

My first program that really did something was written on and for the TRS-80 Model I.  At the time (1978), I was studying for my ham license and had a...