MyDevLib

Database 56 To deal with database and maintain it

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

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

2022Sep15

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

2022Jul24

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

2022Jul6

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

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

2022Jul3