Search results 120

  2. Search results
  3. db
Sorted from new to old.
Card image
Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27
Card image
ReNumber_IDColumn_inTable

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

2023Dec17
Card image
SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12
Card image
Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2
Card image
ANmaFilter3

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

2023Oct13
Card image
BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11
Card image
SqlExec

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

2023Sep3
Card image
Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25
Card image
Refresh Table from View

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

2023Jul19
Card image
DB connection driver

What is the Driver part in ConnectionString

2023Jun2
Card image
ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30
Card image
ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

2023Apr28
Card image
ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23
Card image
DB Functions (By AI)

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

2023Apr23
Card image
WordPress - Excel functions (AI)

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

2023Apr22
Card image
ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14
12...78