Which four Transact-SQL statements should you use?

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.)

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.)

Answer:

Explanation:
http://msdn.microsoft.com/en-us/library/ms190273.aspx



Leave a Reply 2

Your email address will not be published. Required fields are marked *


God

God

2 – 5 – 4 – 6

Gourd

Gourd

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: “<="