Search results 256

Sorted from new to old.

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

NextID_Reset

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

2020Mar31

DB_Connect_Install

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

2020Mar24

DB_Connect

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

2020Mar20

Captcha34

jQuery and bootstrap-based captcha, Restricted Content + Input Validator. ...

2020Mar17

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

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

ASPjson

Read and write json data in and from Classic ASP From

2020Feb3

XorD

Encrypt or decrypt a string using a key Similar to XorC, except you get to ...

2020Jan10

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

BodyYoutubeLink2iframe

Creates youtube embed from link Converts a youtube video link into a youtube ...

2019Dec31

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

1 2 ...9 ...15 16