The CASE expression is frequently used in day-to-day tasks, particularly when preparing reports and conducting data analyses. It analyzes a set of conditions and provides
@@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT
The @@IDENTITY, SCOPE IDENTITY(), and IDENT_CURRENT functions all return the Identity value (ID value) of the recently (latest) inserted record, however, there is a distinction
KUBECTL Basic Commands
Kubectl is a Kubernetes command-line configuration tool that interfaces with a Kubernetes API server. You can use Kubectl to create, inspect, update, and destroy Kubernetes
AUTO UPDATE THE DEFAULT DATE in SQL Server
In a previous post, it was explained how to update the default date or date column in MySQL when a row gets updated. The clause
Answers – Problem Scenarios for Practice
Please refer to the SQL practice questions here. Answers to those problem scenarios are given below. Answer to Problem Scenario # 1 UPDATE tbOrdersTickets SET
JSON Array to ROWS – MySQL
I recently received a request to divide a JSON data type row value containing an array of numbers into multiple rows. That is one value
Big Data & SQL 