Search results 54

  2. Search results
  3. databases
Sorted from new to old.
Card image
HeadingZeros Remove and Add

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

2019May31
Card image
fnGenerateRandomString

SQL function to generate random string I thought it would be easier to find ...

2019May5
Card image
ANmaDB functions

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

2019Apr14
Card image
DBMySQLVBA API

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

2019Feb3
Card image
API in ASP Classic

A simple REST API technique reading record from Access mdb, then generates json ...

2019Feb1
Card image
Shrinking DB

Steps to shrink database in MS SQL

2019Jan6
Card image
MSSQL backup

The practical way I found to backup database (or tables) to be moved into new ...

2019Jan6
Card image
SSTree

Tree code, driven by Access DB A code I found somewhere online that I enhanced ...

2019Jan3
Card image
DB Class

Database Class in Classic ASP An old article I found that helps a lot these ...

2018Dec25
Card image
Import error log

Imports the SQL Server error log into a table, so that it can be queried This ...

2018Sep29
Card image
Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

2018Jul29
Card image
RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29
Card image
MSSQL DB Connection

Connects to MSSQL database from Classic ASP All DB variables need to be ...

2018Jul29
Card image
MySQL DB connection

Connects to MySQL database from Classic ASP All DB variables need to be ...

2018Jul29
Card image
DB_SettingRead_Field

Returns a certain field from Settings table by a SettingName. Similar to ...

2018Jul24
Card image
DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

2018May31
1234