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.
