Which four Transact-SQL statements should you use to develop the solution?

DRAG DROP
You want to add a new GUID column named ProductGUID to a table named dbo.Product that already contains data.
ProductGUID will have a constraint to ensure that it always has a value when new rows are inserted into dbo.Product.
You need to ensure that the new column is assigned a GUID for existing rows.
Which four Transact-SQL statements should you use to develop the solution? (To answer, move the appropriate Transact-SQL segments from the list of SQLsegments to the answer area and arrange them in the correct order.)
Select and Place:

Correct Answer:

Explanation/Reference:
Explanation:
Box 1:
Existing BookGuid can be null.
Box 2:
Box 3: new()
Generate a new global value
Box 4:
Actually, in the real world, you don’t have to use WITH VALUES at the end of the statement and it works just as well. But because the question-specifically states which FOUR TSQL statements to use, we have to include it. Reference: http://msdn.microsoft.com/en-us/library/ms190273.aspx