Question

Write one DDL statement to add a new column AssignDate of date type in ProjAssignment table, which should allow no null values. Because there are already existing rows in the table which have no AssignDate data, your DDL statement must define a default value using current date in this column. When this DDL statement is executed, it will then update the AssignDate of every existing row with the default current date.

Answer 1

Check the explanation

Step-by-step explanation:

A DLL can be classified as a library that comprises of code and data which can be used by more than one program at the same time.

a DDL statement in answering the question above can be seen below:

ALTER ProjAssignment ADD AssignDatw Date DEFAUT getdate() NOT NULL;

Default is keyword to set default date fetch by function getdate() i.e. current date.