Blog Pages

Include columns headers in csv files via grid results

There are few ways to save query results to files.
One of them is direct from the grid results:


But, when you will do it, you will find the csv file without the columns names:



Not so nice…

The solution is quite simple: declare in the options to get also the headers:



Done. Try again – but again – no columns header!!!

Now what?

The solution for that is the most common solution in the IT world: restart – restart SSMS.
Next time – you will get the headers.

No comments:

Post a Comment