SQL 20 Microsoft SQL, MySQL, or any other database languages, this is SQL as language, it is not the same as Database as Category

Card image cap
TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

Card image cap
Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

Card image cap
Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

Card image cap
Most recent in Oracle DB

List the most recently added rows based on a date column.

Card image cap
all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

Card image cap
Random GUID

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

Card image cap
List of Databases

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

Card image cap
Char(39) in SQL table

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

Card image cap
Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

Card image cap
fnGenerateRandomString

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

Card image cap
Shrinking DB

Steps to shrink database in MS SQL

Card image cap
MSSQL backup

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