SQL 31

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

Sorted from new to old.

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

Feb18

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

Feb3

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

Jan30

SQL Cross Apply String_Split with XML Path

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

Jan20

ReNumber_IDColumn_inTable

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

2023Dec17

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

TrimEnters

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

2020Sep19

Reset ID Column

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

2020Feb9

Decode and NVL

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

2020Feb7

Most recent in Oracle DB

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

2020Feb7

all_tab_columns

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

2019Dec22

1 2