As you can see, IS NULL is useful when combined with WHERE to figure out what data you're missing. Sometimes, you'll want to filter out missing values so you only get results which are not NULL. To do ...

The null conditional operator used here would be interpreted by the compiler to mean: If employee is not null, set its user property to the user variable on the right. If employee is null, short ...