Database 63
To deal with database and maintain it
Sorted from new to old.
HTMLTable_NoOfColumns
Gets no of columns in an HTML table. It actually gets the maximum number of ...
CleanArray_2Dim
Cleans an array of 2 dimensions from blank in 1st column. Similar to
MatchIfUp or MatchIfRev
Searching for an item in a column from bottom to top. Will search for item in ...
UniqueRandomID in SQL
Generate new Random ID, unique not duplicated in two columns in two tables. ...
Install/Uninstall SQLNativeClient DB driver
Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...
SQL Cross Apply String_Split with XML Path
SQL select statement to convert list of IDs found in column (from more than row ...
ReNumber_IDColumn_inTable
Reset numbers in ID column, with help from AI. The StoredProcedure will move ...