You have a third-party application that inserts data directly into a table. You add two new columns to the table. These columns cannot accept NULL values and cannot use default constraints. You need to ensure that the new columns do not break the third-party application. What should you do?

Question

Accepted Answer

D. Create an INSTEAD OF INSERT trigger.

Answer

A. Create a DDL trigger.

Answer

B. Create a stored procedure.

Answer

C. Create an AFTER INSERT trigger.

You have a third-party application that inserts data directly into a table. You add two new columns to the table. These columns cannot accept NULL values and cannot use default constraints. You need…

Question

Options

How the community answered

Community Discussion