【单选题】You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column...
A.
Create an INSERT trigger to assign the default value to each item in the table.
B.
Create a CHECK constraint to validate the data and to assign the default value to each item in the table.
C.
Create an UPDATE trigger to update the default value for each new item in the table.
D.
Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.