Search results 53

  2. Search results
  3. databases
Sorted from new to old.
Card image
DBTables

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

2022Apr28
Card image
SumOf_3Filters

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

2021Jan29
Card image
RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

2020Sep7
Card image
NextID_Reset

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

2020Mar31
Card image
DB_Connect_Install

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

2020Mar24
Card image
DB_Connect

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

2020Mar20
Card image
Decode and NVL

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

2020Feb7
Card image
all_tab_columns

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

2019Dec22
Card image
Random GUID

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

2019Dec22
Card image
GeneratePostID

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

2019Dec19
Card image
List of Databases

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

2019Oct6
Card image
Parts-File2Page

A classic ASP include file to read txt file of list into a page using bootstrap ...

2019Oct6
Card image
bs_grid

Bootstrap grid with php server-side example code (jQuery Datagrid plugin) From ...

2019Sep20
Card image
Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

2019Aug31
Card image
DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22
Card image
HeadingZeros Remove and Add

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

2019May31
1234