Duration: 17:36 min
Summary: In this video, we will discuss two items: collation and parsing data. We will start with collation, which is a property of character data. It involves language support, sort order, case sensitivity, accent sensitivity and more. We will look at couple of examples to get all the collations and use ‘Collate’ in a select statement. Then we will shift our attention to parsing data. We will start with Cast and Convert. They are used to convert an input value to some target type. After that, we will cover the features that are added in SQL Server 2012. They are: Try_Cast, Try_Convert, Parse, and Try_Parse. The basic functions will fail if they cannot convert to the specified data type. However, the ones with “Try_” will return null. We will discuss some examples of using each one of those functions.