What is the difference between TRY_CONVERT and Convert? 2016 SQL Server Interview Question

Convert: enables you to convert data stored in one data type to another. The conversion might fail if you attempt to convert between data types where conversion is not possible.
TRY_CONVERT: is the same but if conversion fails, a NULL value is written.

Comments

Archive

Contact Form

Send