Write a single query to show the results of the following attempts to cast data: Casting a
Question:
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 query that will insure the value 'This data is okay' is the only value returned.
Take a screen shot of the SQL windows and results and paste it here.
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last