You are a database developer. You plan to design a database solution by using SQL Server 2008. A stored procedure uses the INSERT, UPDATE, and DELETE statements separately to load data into a table. You need to rewrite the stored procedure to use a single statement to load the data. What should you do?
A.
Write a MERGE statement by using a WHEN MATCHED clause and a WHEN NOT MATCHED BY TARGET clause.
B.
Write a MERGE statement by using a WHEN MATCHED clause and a WHEN NOT MATCHED BY SOURCE clause.
C.
Write a MERGE statement by using a WHEN MATCHED clause, a WHEN NOT MATCHED BY TARGET clause, and a WHEN NOT MATCHED BY SOURCE clause.
D.
Write a MERGE statement by using a WHEN MATCHED clause and two WHEN NOT MATCHED BY SOURCE clauses.