DRAG DROP
You are creating a sales data warehouse. When a product exists in the product dimension,
you update the product name. When a product does not exist, you insert a new record.
In the current implementation, the DimProduct table must be scanned twice, once for the
insert and again for the update. As a result, inserts and updates to the DimProduct table take
longer than expected.
You need to create a solution that uses a single command to perform an update and an
insert.
How should you use a MERGE T-SQL statement to accomplish this goal? (To answer, drag
the appropriate answer choice from the list of options to the correct location or locations in
the answer area.
You may need to drag the split bar between panes or scroll to view content.)
Answer: 
Explanation:
http://msdn.microsoft.com/en-us/library/bb510625.aspx
http://msdn.microsoft.com/en-us/library/cc280522.aspx