IIF, Coalesce and Catalog Views - T-SQL Step by Step Course - Lesson 15 | SQL courses

Duration: 17:30 min

Summary: In this video, we will start our discussion with iif and coalesce. Iif is a shortcut for the if statement. It returns one of two values depending on whether the Boolean expression evaluates to true or false. Coalesce takes a list of parameters, and returns that first one that is not null. This is very powerful because the list of parameters is not limited. After we are done with iif and coalesce, we move to an important concept of catalog views. It is very important to know information about the objects that exist within the database. Objects could be tables, views, stored procedures, functions…. In some situations we need to know the schema name, the table name, it the views that exist within the database. We will see how we can retrieve that information using catalog views. This discussion will continue in the next video.