SQL: Odd TRY_CAST and TRY_CONVERT Behavior
Here’s a quick T-SQL test for you.
Without looking below to see the answer first, try to guess what each of these statements will produce as output:
And to slightly distract you from checking out the answers yet, here is another wise-looking owl who is thinking about the answers, and warning you not to look further down the page yet:
Anyway, here’s what happens when you run this T-SQL in SQL Server:
2017-12-04