0
good morning!
I need to insert the return data of a Select into a file . txt containing the column names and separating the data by ";"
How can I do this process?
Grateful From Now
0
good morning!
I need to insert the return data of a Select into a file . txt containing the column names and separating the data by ";"
How can I do this process?
Grateful From Now
1
You can do your query normally, then right-click where it is marked red in the image below and save as CSV, later open the file with Notepad, will be with headers and separated by ";" as below.
IDT_CLIENTE;COD_COMERC;COD_FILIAL;IND_WHITE_LABEL_ATIVO
1;4236304;5556251;NULL
2;4464027;5556452;NULL
20;4261114;5556255;1
22;4236304;5556252;0
24;4503199;5556553;0
0
Or you can go to Wizard: - right click on the seat - tasks - export data... - at source, select SQL Server Native Client (last option) - in destination, flat file Destination, puts the desired path, checks whether Unicode or not, it is optional to put a qualifier (for example, all fields start and end with quotes) - copy data... - select the table, enter the line delimiter (usually CR LF) and finally the column delimiter (in your case semicolon) - Finish
Browser other questions tagged sql sql-server txt
You are not signed in. Login or sign up in order to post.
I think this post will help you. https://stackoverflow.com/a/17782033/4312593
– Netinho Santos