How to Export SQL table records using a Windows Batch file (.bat) | Ms SQL

Great video but you did not mention why you copy the batch file to another location. Does it need to be in another location in order for you to be able to run the file.

Will this work for long blocks of SQL codes too ?

Does it work if my SQL database needs to connect with the company network / VPN ?

I do not have it in columns of excel. It is just one row full of text separated by comma(one column) How did you manage to get the data each in separate column -such instantly ?

Very informative sir! But one question,can this be automated? I mean can this run automatically and send the csv as email attachment to users?

Please make csv file to sql server

I need to generate the csv files with the different naming convention at particular location in our server by running task scheduler which will invoke that bat file everyday at particular time . is it possible?

where is mistake not run query??
sqlcmd -s DESKTOP-0331Q75 -d TestDB -E -Q "select * from dbo.dept" -s "," -o "E:\ss.csv"

Thank you for the video.
How to save the output file in .xlsx format?

cool man am loving your videos brother

Can please make a videos on Migration process ..

Sir pls make a video on upgrade and migration

And pls make another video on expected question on every topic like - backup, restore, DR plans, pt etc.. So that we can prepare easily... Tq

Good explaination sir

Great one

Easy understandable.. thank you..

Why do we need batch files other than generating files? How common is it?