Exploring SQL Server LEN() Function
SQL Server supports different data types to store relevant data in SQL tables. These data types can...
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
In many scenarios, date and time information is loaded and stored in the text format. Converting these values to the date/time type is a...
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....
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 SUBSTRING SQL server command. It is similar to...
SQL Server Primary Key
Across all major RDBMS products, Primary Key in SQL constraints has a vital role. They identify the...
Drop Temp Table in SQL Server and PostgreSQL
This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the name suggests, temporary tables are used...
Getting Started with SQL Server
This documentation section presents the topics on SQL Server
User-Defined Functions in SQL Server
User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of....
