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.)
Explanation:
http://msdn.microsoft.com/en-us/library/ms190273.aspx
2 – 5 – 4 – 6
Given answer is correct 2 – 5 – 6 – 3
EOMONTH(GETDATE(),-1) will return the last day of the month so it needs to be included: “<="