Question

Part 1

Write a single query to show the results of the following attempts to cast data: Casting a date literal to an int data type will display Fail
Casting a date literal to a date data type will display Success
Casting a date literal to int data type will display No if it fails and Yes if it succeeds Casting a date literal to date data type will display No if it fails and Yes if it succeeds Take a screen shot of the SQL windows and results and paste it here.
Part 2
Rewrite the query from Part 1 but attempt to parse the data this time instead of cast. Take a screen shot of the SQL windows and results and paste it here.
Part 3
Using the WideWorldImporters database and the Application schema return the FullName, PhoneNumber, and CustomFields from the table People. Only return rows where the CustomFields value contains a NULL. Do not display NULL but the value ‘NONE’
Take a screen shot of the SQL windows and results and paste it here.
Part 4
Assume a select statement is returning fields and the rows may have nulls. Assuming the following values (NULL, NULL, NULL, ‘This data is okay’) write the que

Answer 1

In SQL, casting a date literal to an int data type will generally fail, while casting it to a date data type should succeed. To handle potential casts and parses that may fail, one can use the TRY_CAST and TRY_PARSE functions. For extracting data from the WideWorldImporters database and replacing NULL with 'NONE', the COALESCE function should be utilized.

Step-by-step explanation:

In Part 1 of the question, the student is asked to write a single query that demonstrates the results of casting data types. For example, casting a date literal to an int data type will fail, while casting it to a date data type will succeed. The student is also asked to take a screenshot of the SQL windows and results.

In Part 2, the student is asked to rewrite the query from Part 1, but this time attempts to parse the data instead of casting it. In Part 3, the student is given a specific scenario using the WideWorldImporters database.

They are asked to return the FullName, PhoneNumber, and CustomFields from the People table, but only for rows where the CustomFields value contains a NULL. The NULL value should be displayed as 'NONE'. Part 4 of the question is cut off, so it is unclear what it is asking for.