SQL 31 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
UniqueRandomID in SQL

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

Card image cap
SQL instr

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

Card image cap
Random Number in SQL

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

Card image cap
SQL Cross Apply String_Split with XML Path

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

Card image cap
ReNumber_IDColumn_inTable

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

Card image cap
SQL Date from DateTime

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

Card image cap
Latest records date and count

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

Card image cap
Refresh Table from View

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

Card image cap
DB connection driver

What is the Driver part in ConnectionString

Card image cap
SQL Related posts

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

Card image cap
Hide SQL table

A simple easy way to hide tables in SQL Server

Card image cap
TrimEnters

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