Exam 70-461 topic 1 question 185 discussion

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 SQL- segments to the answer area and arrange them in the correct order.)
Select and Place:

Suggested Answer:
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