Home » Microsoft » 70-461 v.2 » Which Transact-SQL statement should you use?
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. Option A
B. Option B
C. Option C
D. Option D
Correct Answer: B
Explanation/Reference:
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/librarv/ms177523.aspx