PdfPrep.com

?

DRAG DROP

You have a project management application. The application uses a Microsoft SQL Server database to store data. You are developing a software bug tracking add-on for the application.

The add-on must meet the following requirements:

?- Allow case sensitive searches for product.

?- Filter search results based on exact text in the description.

?- Support multibyte Unicode characters.

You run the following Transact-SQL statement:

You need to display a comma separated list of all product bugs filed by a user named User1.

How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL

segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Box 1: @List NVARCHAR (MAX) = ‘ ‘ Box 2: @List = @List + ‘,’ + Product

Not: @List Table is an invalid statement

References: https://docs.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-2017

Exit mobile version