Browse codes

Database 45 To deal with database and maintain it

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

Sep3

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

Jul19

What is the Driver part in ConnectionString

Jun2

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

Apr23

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

Apr22

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

Apr12

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

2022Dec23

Removes duplication in table in 1 or more columns. Will work in sheet, ...

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