Is there a way to prevent SSMS 2012 from adding the word 'NULL' to CSV exports?
Steps to reproduce behavior:
- Create a new query (Ctrl+N)
- Select Query | Results To | Results to Grid (Ctrl+D)
- Run query:
SELECT getdate() NOW, NULL DUMMY
; results in one row and two columns, the second column displays ‘NULL' - Right click the results pane and choose Save Results As…; save the file as CSV
- Open the file with Notepad (view the ‘raw’ values)
Actual result:
NOW,DUMMY
2015-10-16 10:25:28.403,NULL
Desired result:
NOW,DUMMY
2015-10-16 10:25:28.403,
Is there a setting that will produce the desire result? Do newer versions of SSMS work differently in this regard?
SELECT getdate() NOW, '' DUMMY
? Just don't select NULL, select an empty string instead.