Database 68

To deal with database and maintain it

Sorted from new to old.

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

2024Apr8

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

2024Feb18

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

2024Feb8

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

2023Apr22

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

1 2 3 4 5