SSMS 2012 CSV exports
You could use COALESCE(NullableColumn,'') for any column you don't want to export with NULL values.

That COALESCE will output zero-length strings instead.

Most of the time, however, it is important to know the difference between a zero-length string and a NULL value in exported data.

You're sample query would become:

SELECT getdate() NOW, COALESCE(NULL,'') DUMMY;


Although, I'd really prefer to see it as:

SELECT [Now] = getdate()
    , Dummy = COALESCE(NULL,'');


Putting the column alias at the beginning of the line makes it easier to find columns referenced in the output when doing debugging work down the road.