MyDevLib

Database 61 To deal with database and maintain it

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

Jan20

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

2023Dec17

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

2023Nov27

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

2023Oct13

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

2023Sep3

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

2023Jul19

What is the Driver part in ConnectionString

2023Jun2

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

2023Apr23

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

2023Apr22

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

2023Apr12

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

2022Dec23

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

2022Sep25