Export SQL Table to CSV with Custom Header (Change in Header Name)

Question

TABLE-A

Client_Code   Client_Name   POST_HC_STK
123              Sam           100
456              Lily          500
568              Maria         200
789              Champ         300

Want Table output as under in CSV File

Client Code  Client Name    Post Haircut Stock
123              Sam           100
456              Lily          500
568              Maria         200
789              Champ         300

How to export Table-A with a change in column header into a CSV?

Is there any Code/Scrip/Query which can use to Export output in to Csv File? — Mittal
– Mittal, Commented Nov 23, 2017 at 13:25

SqlKindaGuy · Accepted Answer · 2017-11-23 13:25:21Z

3

Simply write a select where you give your columnnames another ALIAS.

You can use it 2 ways.

You can export to CSV though your database in Management Studio

You can add it as OLE DB Source in SSIS and then add a flat file destination which points to a CSV File.

SQL Query

SELECT 
Client_Code as [Client Code]
,Client_Name as [Client Name]
,POST_HC_STK as [Post Haircut Stock]
FROM TableA

You can also write it like this - Which in my opinon is easier to read:

SELECT 
[Client Code]        = Client_Code,
[Client Name]        = Client_Name,
[Post Haircut Stock] = POST_HC_STK
FROM TableA

edited Nov 23, 2017 at 13:25

answered Nov 23, 2017 at 13:20

SqlKindaGuy

3,6172 gold badges17 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export SQL Table to CSV with Custom Header (Change in Header Name)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related