Slava Murygin shows how you can recover from a nasty TRY_PARSE error:
In my previous post I outlined very dangerous SQL Server problem, caused by usually not very harmful commands “PARSE” and “TRY_PARSE“: Having “NaN” value for REAL and FLOAT producing severe error.
This post will be about a major issue it causes and on how to fight it.
Will start from generating the problem.
Attention: Do not run that in production!!!
Slava’s serious about not running the code in a real environment.