Câu 42: 70-461: MCSA Querying Microsoft SQL Server 2012/2014

SIMULATION -You create a table by using the following Transact-SQL Statement: You need to return a result set that has a single column named DisplayInformation. The result set must contain the Name value if the Name value is NOT NULL, otherwise the result set must contain the SubName value. Part of the correct Transact-SQL has been provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within the code that has been provided as well as below it.

1. A. SELECT IIF(Name IS NOT NULL, Name, SubName) AS DisplayInformation — đáp án hiện tại