New Transact SQL Video Tutorial: Using Defaults to Avoid Using NULLs in Your Database (SQL Server 2000)

Using Defaults to Avoid Using NULLs in Your Database (SQL Server 2000) - view details

There seems to be two camps with respect to database design in SQL Server with respect to NULLs in the database: one group believes that NULLs are unnecessary and should not be allowed in the database while the other sort of shrugs their shoulders and says, "I'll use NULLs if it makes sense to use NULLs."; in other words, they don't go out of their way to avoid NULLs.

This video shows you how you can design your tables so that the columns do not have to allow NULLs using a Gender and Address1/Address2 example.

Highlights from this video:

• Address schemes in the database
• DDL syntax for DEFAULT constraints
• DDL syntax for ALTER TABLE
• How IDENTITY columns work internally in SQL Server
• How defaults apply to columns that allow NULLs

• Category: Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More
• Skill Level: 200 (Beginner - Intermediate)
• Length: 9:06 (5.07MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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