December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
The TRY_CONVERT Function
The TRY_CONVERT function available in SQL Server 2012 is similar to the TRY_PARSE function in that if the conversion is successful, it returns the value as the specified data type. Otherwise, it returns a NULL value. However, if you request a conversion that is explicitly not permitted, TRY_CONVERT fails with an error.
Like CONVERT, TRY_CONVERT can handle converting to data types other than integer or date and time values.