DBTable2CSV

Exports table into CSV from ASP Classic function.

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

RRRow-asp-mdb-Ajax.zip

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

DB_Connect_Install.zip

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

Random GUID

Generate a random GUID using oracle db workbench Also add timestamp to ensure ...

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

List of Databases

Script to list databases available in a server using ADODB connection From