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