You use a Microsoft

SQL Server database that contains a table named BlogEntry that has the following columns:

Id is the Primary Key.

You need to append the -This is in a draft stage- string to the Summary column of the recent 10 entries based on the values in EntryDateTime.

Which Transact-SQL statement should you use?

A.

B.

C.

D.

A. Option A

B. Option B

C. Option C

D. Option D

Explanation:

The UPDATE SET colum_name.WRITE (expression,@Offset,@Length) command specifies that a section of the value of column_name is to be modified. expression replaces @Length units starting from @Offset of column_name.

If @Offset is NULL, the update operation appends expression at the end of the existing column_name value and @Length is ignored.

Incorrect Answers:

C: The column must be ordered.

References: https://msdn.microsoft.com/en-us/library/ms177523.aspx