Database 51 To deal with database and maintain it
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 ...
Refresh Table from View
Convert SQL View into table for speed reading. Using views a lot, I needed a ...
WordPress - Excel functions (AI)
3 functions to download posts, adds new post and to upload and set featured ...