Microsoft SQL Server 2000
Best Practices
There are 2 ways:
1. Define a default on each column
if column already exists, update it, then put the default on on
2. Use the ISNULL function
select isnull(Quantity,0), isnull(Address2,'')