Similar codes
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
ANmaSQL_UpdateDateStatement
Creates "Update Table " SQL statements to be executed inside SQL to modify ...
2022Jul4
DB_Connect_Install
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
2020Mar24
LastInsertedID_SQL
Get the ID of the last inserted record in a table. There are other methods, ...
2019Jul18
NextID_Reset
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
Records Affected by Execute command
Records affected by sql Execute command https://docs.microsoft. ...
2018Sep1
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
DB_Read1Row (DB_Read1stRow)
Reads from a table in a DB Reads only the first row, and return a string ...
2018Apr21