The SQL FULL OUTER JOIN combines two tables based on a common column and chooses records from both tables that match the values of the
Using a User Defined Function while adding a column
I tried to figure out how to add the computation expression for a computed column using a user-defined function that I discovered while visiting an
Can we alter the computed column in SQL Server
Can we alter a computed column in SQL Server? The answer is- NO. A calculated column is basically a virtual column that isn’t physically stored
SQL Server – Practice CASE Expression
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
Big Data and SQL 