FREE TRIAL  SQL 2012 PROGRAMMING  SEARCH
SQL Server Scripts SQL 2005 SQL 2008 Articles
SQL JOBS NEWS FORMAT DEV JOBS
How to eliminate NULLs?

There are 2 ways:

1. Define a default on each column if appropriate

if column already exists, update it first, then put the default on

2. Use the ISNULL or COALESCE functions:

select isnull(Quantity,0), isnull(Address2,'')

 

Related articles:

Strategies for approaching NULL values with SQL Server

Using Nulls in SQL Server

Handling NULL values in SQL Server 2005

 

Exam Prep 70-461
Exam 70-461