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

SIMULATION -You have a view named Person.vAdditionalContactInfo that uses data from a table named Customers. The Customers table was created by running the followingTransact-SQL statement: You need to create a query that returns the first and last names of a customer from the view. If the CustomerID column does not have a value defined, the following message must be added to the query result: "Customer ID Does Not Exist."Construct the query using the following quidelines: ✑ Do not use aliases for column or table names. ✑ Display the columns in the same order as they are defined in the Customers table. 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 code that has been provided as well as below it.

1. A. Please review the explanation part for this answer. 1 SELECT FirstName, LastName, CustomerID =2 CASE3 WHEN CustomerID IS NULL THEN "Customer ID Does Not Exist"4 ELSE CustomerID5 END6 FROM Person.vAdditionalContactInfo;To line 1 add: CustomerID =To line 2 add: CASE -To line 3 add: IS NULL -To line 5 add: END -References:https://technet.microsoft.com/en-us/library/ms181765(v=sql.105).aspx https://docs.microsoft.com/en-us/sql/t-sql/queries/is-null-transact-sql — đáp án hiện tại