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)
NOW,DUMMY 2015-10-16 10:25:28.403,NULL
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?