Similar codes

code image
NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

code image
Records Affected by Execute command

Records affected by sql Execute command https://docs.microsoft. ...

2018Sep1

code image
ReNumber_IDColumn_inTable

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

2023Dec17

code image
SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Jan20

code image
DB Functions (By AI)

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

2023Apr23

code image
ANmaSQL_UpdateDateStatement

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

2022Jul4

code image
Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

Nov3

code image
LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

2019Jul18

code image
RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29

Recently by developer

code image
HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

Sun 1PM

code image
ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

Sun 1PM

code image
ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

Jan8

code image
ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

Jan8

Random Codes

code image
Sidebar navbar

Bootstrap side navbar (sidebar) Can be pushed to left or right From

2019Aug8

code image
Flexselect

Flexible select dropdown in jQuery From

2019Jul9

code image
XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

2018Aug16

code image
ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14