What should you implement?

You have a table named AuditTrail that tracks modifications to data in other tables. The AuditTrail table is updated by many processes. Data input into AuditTrail may contain improperly formatted date time values. You implement a process that retrieves data from the various columns in AuditTrail, but sometimes the process throws an error when it is unable to convert the data into valid date time values.

You need to convert the data into a valid date time value using the en-US format culture code. If the conversion fails, a null value must be returned in the column output. The conversion process must not throw an error.

What should you implement?
A . the COALESCE function
B . a view
C . a table-valued function
D . the TRY PARSE function
E . a stored procedure
F . the ISNULL function
G . a scalar function
H . the TRY CONVERT function

View Answer

Answer: H