|
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
|
