Search results 82

Sorted from new to old.

DB_Connect_Install

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

2020Mar24

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

DB_Connect

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

2020Mar20

Online Wordpress password hash generator

An online tool to generate password hash for wordpress, tried it just today ...

2020Feb13

Decode and NVL

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

2020Feb7

Most recent in Oracle DB

List the most recently added rows based on a date column.

2020Feb7

all_tab_columns

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

2019Dec22

Random GUID

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

2019Dec22

GeneratePostID

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

2019Dec19

List of Databases

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

2019Oct6

BS Star system

Bootstrap, Font Awesome rating stars system, to replace options for users to ...

2019Sep26

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

2019May31

ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

2019Apr14

ANma_HTML2DB + ANma_DB2HTML + ...

Convert HTML text into DB-safe string, by converting some characters as below. ...

2019Feb7

DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

2019Feb3

1 2 3 ...5 6