Home page Jan van de Weijer



SQL

Last year I was forced to use SQL. I encountered a lot of problems which I solved with some handy scripts and I would like to share this.

1. A vbscript that will execute an SQL script, a vbscript that will produce a CSV and a vbscript that to inetractively execute an SQL and producing an Excel spreadsheet Download
2. A GUI program that will create a script to invoke the scripts as mentioned under point 1. Download
3. Two ASP files. One to list all SQL files within one folder and one to execut an SQL. The default.asp will list all files in one folder and produces a link within a browser. When the link is selected the sql.asp will execute the SQL and will display the result. Download