Free Transact SQL Video Tutorial: SET Commands for Working with NULL values

SET Commands for Working with NULL values - download

Do you know the difference between ANSI NULLS and ANSI NULL DEFAULT (or is there a difference)? If you aren't sure what an "ANSI" is, then you definitely will want to watch this video! If you have trouble with NULLs or just want a good explanation of what NULLs are and how three-valued logic works in relational databases, you'll also want to watch this video.

Highlights from this video:

• Explanation of NULLs
• Using SET commands and database options to control how SQL Server works with NULLs
• Concatentation and arithmetic with NULL values
• Changing the default behavior with CONCAT_NULL_YIELDS_NULL
• ISNULL and COALESCE
• Using "= NULL" and IS NULL
• Determining SET options with DBCC USEROPTIONS
• Defaults of SET options, database options and connection options
• Variable assigment and whether unassigned variables are null, empty or 0

• Category: SQL Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 8:48 (6.39MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video