Random GUID

Generate a random GUID using oracle db workbench Also add timestamp to ensure ...

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

List of Databases

Script to list databases available in a server using ADODB connection From

Country list in arabic

List of countries codes and names in Arabic, you do not know when you need it ...

Country-list-arabic-master.zip

Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

LastInsertedID_SQL

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

HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

fnGenerateRandomString

SQL function to generate random string I thought it would be easier to find ...

ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

Shrinking DB

Steps to shrink database in MS SQL

MSSQL backup

The practical way I found to backup database (or tables) to be moved into new ...

Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...