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

  2. Languages
  3. SQL
Card image cap
SQL Date from DateTime

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

Wed 12PM
Card image cap
Latest records date and count

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

Nov2
Card image cap
Refresh Table from View

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

Jul19
Card image cap
DB connection driver

What is the Driver part in ConnectionString

Jun2
Card image cap
SQL Related posts

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

2022Jul6
Card image cap
Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23
Card image cap
TrimEnters

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

2020Sep19
Card image cap
Reset ID Column

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

2020Feb9
Card image cap
Decode and NVL

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

2020Feb7
Card image cap
Most recent in Oracle DB

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

2020Feb7
Card image cap
all_tab_columns

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

2019Dec22
Card image cap
Random GUID

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

2019Dec22