SQL IN operator
The SQL IN statement matches a specified value from a list or subquery. It reduces our efforts to...
Syntax of LINQ GroupBy Method in C#
We are continuing our series dedicated to LINQ technologies with a more detailed look at some methods available under the LINQ umbrella....
How to Change Default MySQL Port in Windows 10
A network port is a communication endpoint used by applications, incoming connections, and external devices to the computer/server or...
An Overview of the SQL Variables Usage
The SQL variable is a local variable that can store a single data value temporarily. Its lifecycle...
Exploring SQL Server LEN() Function
SQL Server supports different data types to store relevant data in SQL tables. These data types can be integer, float, Varchar, NVARCHAR,...
User-Defined Data Types In SQL Server
SQL Server platform comes with many data types, but there are cases when they are not sufficient. Or, custom data types could help make...
Varchar To Date Conversions In SQL Server
Introduction In many scenarios, date and time information is loaded and stored in the text format....
Automation of Database Maintenance in SQL Server 2019 Express Edition
This article explains how to automate the database maintenance tasks in SQL Server Express Edition. In terms of automation of database...
A Cartesian Product in SQL – Work Scenario Application
A Cartesian Product is a product of two sets of elements where each element in one set is multiplied by every other element of the other...
SUBSTRING Command in SQL: A Primer
Similar to my article regarding the SQL Server STUFF command, today we will be examining the...