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,'')