SQL export data to csv (Automatically)

Microsoft Help

[juanignacio]

Simple and ready to implement. That's what people look for in this kind of video.

[waqarmehdi]

The most exact video I was looking for.
Thank God that I stumbled upon your video.
Thanks a ton.

[andilerodney]

Subbed. Thank you for this well explained video.

[gracechew]

this video is worked and very simple to follow! Thank you very much!

[aeronrogano]

Hi, may i know how can i export the data to my template on a specific tab sheet?

[grt]

Perfect!
You make the video and put the command in the Desciption ;-)
Thanks friend!

[cencom]

very good video, easy to follow along. Question though, is there a way not to have the 2nd row in the csv file that has all the not to appear in the csv file?

[MarshalPilgreen]

Thank you! As an FYI, you can also put your query in a file like this:

SQLCMD -S ChangeToServerName -d ChangeToDatabaseName -E -i "c:\myquery.sql" -s ", " -o "D:\Result\Excel Export\DailySales.csv"

[CozBlueOcean]

Thank you so very much for this video. Very informative and simple to understand and follow. A++++

[teimurazgamkrelidze]

Very useful video, thank you very much, but if there is a comma in the product name, it will automatically split the name into two parts and put these parts in different rows. so how to avoid this problem if there is a comma in the product name?

[noahsitu]

is that possible that when exporting the file we include the time and date in the file name?

[tonyp]

Thank you so much for this video! Very informative. Is there a way to place a timestamp on the file to know when it was ran, for archiving purposes?

[mollyoesterling]

Hi Mas! - Great video! If I wanted to change the -E parameter to a username and password, what would the syntax look like?

[modheenmaddy]

can we export SQL results to text file using batch file, and I have nvarchar columns to export.

[Achinta-lkex]

I am not getting the output file instead getting a file named "cast(getdate() as date). In my query i have a condition where reportdate> cast(GetDate() as date) . In sql my query is running fine

[imprzck]

Thanks a lot man, you really helped me a lot

[thehiennguyen]

thanks for you video!
can we compress to reduce storage capacity?

[santanuchakraborty]

Thank you, This is excellent and really useful. I have one question can we generate the CSV file without column heading and the dotted line? it will be very helpful for me.
Thank you in advance.

[vishnusalukuti]

This is excellent and really useful. It would be nice if you could explain how to switch Windows authentication to I.D. and Password.

[sarahelen]

Hello, do you know how to do the same but from SQL Server to .xls file? I mean not a .csv file. I did it in the past but I can't replicate it again :( I think it was with bcp or OpenRowSet. Thank you in advance