You are a database developer of a Microsoft SQL Server that hosts a business-critical high-activity OLTP system.
The database contains a table named Customer that has more than one million records. The table has the following defintion:
Customer data is updates in an external system. These changes are copied into a staging table on a weekly basis. This table has the following definition.
You need to write a Transact-SQL statement that will update the records in the Customer table by using the values in the Customer_Staging table that has matching CustomerID values. You must ensure that only one record is updated at a time.
Which Transact-SQL query should you run?
A.
B.
C.
D.
Comments