Similar codes
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
ReNumber_IDColumn_inTable
Reset numbers in ID column, with help from AI. The StoredProcedure will move ...
Dec17
SQL Cross Apply String_Split with XML Path
SQL select statement to convert list of IDs found in column (from more than row ...
Jan20
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
LastInsertedID_SQL
Get the ID of the last inserted record in a table. There are other methods, ...
2019Jul18
RandomRecords
Returns random IDs (or any column) from SQL Database table, passing number of ...
2018Jul29
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 ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
ListBox bug with TabIndex
Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...
Apr15
Webfont generater
Online tool. Generate web font to be used in websites. When trying to fix ...
Nov27
ContainerHTMLTag_Index
Returns location of the tag that enclosing the location provided inside HTML ...
Oct22
Error_Raise
To raise a friendly error message with option to show custom error number and ...
2018Jul7