Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Common Functions in MS SQL Server

Introduction
2. The Product table
The ISNULL() function
The COALESCE() function
The NULLIF() function
Summary

Instruction

Before we start, we'll introduce today's guest: Mr. Amund. He's the CEO of Hjem for deg—a company that sells furniture and home accessories.

He's agreed to show us a snippet of his company's Product table. Let's see what's in there.

Exercise

Select all columns from the Product table, and study their contents.

Stuck? Here's a hint!

Use * to select all columns.