Domain.com uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?
A.
Create a FOR trigger.
B.
Create an INSTEAD OF trigger.
C.
Create an AFTER trigger.
D.
Create a DDL trigger.
Explanation:
By using an INSTEAD OF trigger you can write a job that inserts the records into the table and if the record already exists the INSTEAD of trigger will fire and execute an update of the record instead of an insert.