Search results 53

Sorted from new to old.

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

May2

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Mar12

Install/Uninstall SQLNativeClient DB driver

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

2024Feb8

ReNumber_IDColumn_inTable

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

2023Dec17

XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

2023Nov26

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

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

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

SQL Related posts

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

2022Jul6

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31

1 2 3 4