Category Archives: SQL

queries, admin, etc

MS SQL Database CSV Export – Part 2

In a previous post, we described a method to query a MS SQL database and export the results to a CSV file using a batch script. This post will expand on the previous solution to include a way to upload the CSV file to a PHP web server using cURL. Also, the PHP page can generate an email… Read More »

MS SQL Database CSV Export – Part 1

The following process describes how to connect to a MSSQL database, run a query, and save the result as a CSV file; all via command line so it can be easily added to a batch file and scheduled to run via Task Scheduler or any other mechanism. In “part 2”, I will describe how to create a simple… Read More »