Quotation marks in an exported csv file from sql

As probably known, we can export data to a csv file from the export wizard.

But, if the text columns have the “,” – that it is the column separate sign – all the csv file will be not arranged.

One possible solution is to declare Quotation marks to all columns, and it will help to separate the columns.

Update string add spaces to the input text

Can it be that we will try to update a string and SQL add spaces to it while updating the column?

Answer: Yes!

Char and nchar data types fill the string to the defined text.

An example: 

If a column declared as char 3, and we will run

UPDATE MyTable SET CharColumn = 'AA' WHERE id = 1

and the value there will be set to 'AA ' !

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.