Here is some code to do a full outer join on three tables. In the example, the three full outer joins are done on two columns , but it works just the same if you only have a single join column. CREATE TABLE ZA (T CHAR(1), O CHAR(1)) CREATE TABLE ZB (T CHAR(1), O CHAR(1)) […]

Here is how to Export Windows Scheduled Task Information to File with Command Line: schtasks /query /fo CSV /v >> scheduled_task_metadata.csv This will dump a list of scheduled tasks and their advanced settings to a CSV file called “scheduled_task_metadata.cs” to whichever location you run the command prompt from. If you don’t want the windows scheduled […]

MYSQL Statements and clauses ALTER DATABASE ALTER TABLE ALTER VIEW ANALYZE TABLE BACKUP TABLE CACHE INDEX CHANGE MASTER TO CHECK TABLE CHECKSUM TABLE COMMIT CREATE DATABASE CREATE INDEX CREATE TABLE CREATE VIEW DELETE DESCRIBE DO DROP DATABASE DROP INDEX DROP TABLE DROP USER DROP VIEW EXPLAIN FLUSH GRANT HANDLER INSERT JOIN KILL LOAD DATA FROM […]

These are some MySql commands (most run at the command line in linux) that I’ve been collecting since getting a few sites set up on linode. The “#” indicates that it is to be run from the unix shell. When you see “mysql>” the command is to be run from the MySQL command prompt after […]

What is a Disconnected Recordset? A Disconnected Recordset is A recordset object that exists in an application, but does not have an associated data connection associated with it. Why use a Disconnected Recordset? The ADO Recordset is considered an extremely “rich object model” which means it provides more functionality than say, an array. Also, you can load […]

This is a simple VBS VBScript that I use to delete all files in a given folder on a machine. It is particularly useful to delete internet cache files or cookies. You can set a scheduled job actually, to perform this task nightly. This script could be easily modified to, say, clear out your temporary […]

I needed a quick vbscript to terminate a specific windows process that seemed to hang. This is the script that will do it. It uses SQL to lookup the process name from the win32_process list, then uses the terminate function to close it. NOTE: this vbs to terminate a windows process was only tested on […]

Robar's Pages Halifax Where is the Fairview Overpass? Saint Mary's University (SMU) Switches from WebCT to BlackBoard for Online Course Tools Halifax Nova Scotia Campground With Wireless Internet Access Wi-Fi Internet Ripoff Alert – Domain Registry of Canada Scam Improving Adsense CTR in Forum Pages Adsense Ads Allowed on Search on 404 Pages TOS? Adsense […]