Working with NULLs in Expressions in SQL Server 2005/2008/R2

This video is part of LearnItFirst’s Writing Queries for SQL Server (2005/2008/R2 Edition) course. More information on this video and course is available here:

http://www.learnitfirst.com/Course160

In this video Scott will cover working with NULLs in expressions. Scott will define functions, and how they work in SQL. Dealing with NULLs in predicates was a topic that was covered in chapter two, and now in this video you will see how to deal with NULLs in expressions.

Highlights from this video:

– Functions in SQL
– Scalar functions
– Where can they be used?
– Nested
– NULLs in expressions
– Ignore unknowns
– ISNULL()
– T-SQL
– COALESCE()
– NULLIF()
– ISO

and much more…