Exam 70-462 topic 2 question 119 discussion

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

Suggested Answer:
Reference:
http://msdn.microsoft.com/en-us/library/ms190273.aspx