Database 66

To deal with database and maintain it
Sorted from new to old.
Card image
Install/Uninstall SQLNativeClient DB driver

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

Card image
SQL Cross Apply String_Split with XML Path

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

Card image
ReNumber_IDColumn_inTable

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

Card image
ReverseArray

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

Card image
ANmaFilter3

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

Card image
SqlExec

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

Card image
Refresh Table from View

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

Card image
DB connection driver

What is the Driver part in ConnectionString

Card image
DB Functions (By AI)

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

Card image
WordPress - Excel functions (AI)

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

Card image
Arabic in MySQL

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

Card image
ANmaVLookup

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

Card image
ANmaRemoveDuplicates

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

Card image
ANmAdvancedFilter

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

Card image
ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

Card image
SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...