SQL commands

An overview of DIFFERENCE and SOUNDEX SQL functions

January 18, 2022 by Hadi Fadlallah

This article gives an overview of DIFFERENCE and SOUNDEX SQL Server built-in system functions. It explains how to use those functions and how do they work.

Getting started with SQL Server CLR functions

January 11, 2022 by Hadi Fadlallah

This article will explain how to create a SQL Server CLR function stored in a C# class library without creating a SQL Server database project. We will first briefly explain the concept of .NET common language runtime (CLR) and then build a C# class library using the .NET framework. Then, we will use the C# library to create user-defined CLR functions in SQL Server.

Understanding the SQL MIN statement and its use cases

December 3, 2021 by Manvendra Singh

Today, I will explain an overview of the SQL MIN () function along with its several use cases in this article. This function is categorized under aggregate functions in SQL Server. Aggregate functions perform a calculation on a set of values from a specified expression and return a single value in their output. Aggregate functions return the same value every time you execute them unless your source data is changed.

SQL commands in SQL Server

November 22, 2021 by Daniel Calbimonte

Introduction

If you are here, it means that you want to learn the SQL commands. This article applies to SQL Server especially, but most of the theory is similar to Oracle, MySQL, MariaDB, PostgreSQL, and other databases. The SQL commands are instructions that we send to the database to get information, manipulate the information or create objects, modify them, and handle the access to the information.

INDEXPROPERTY() function in SQL Database

November 22, 2021 by Rajendra Gupta

This article will give an insight into the INDEXPROPERTY() function in SQL Databases.

SQL Syntax Checker Tools

October 27, 2021 by Esat Erkec

In this article, we will look at the 2 different SQL syntax checker tools that help to find the syntax errors of the queries without executing them.

SQL LEFT function in queries

October 22, 2021 by Esat Erkec

In this article, we will learn how to use SQL LEFT function with straightforward examples.

An overview of SQL Comments

October 19, 2021 by Rajendra Gupta

In a typical database, we have multi lines or page SQL statements in a view, SQL statement or the stored procedure. Also, multiple developers change the T-SQL, and it becomes difficult to track who altered the code and for what reason.

How to write SQL queries with spaces in column names

September 29, 2021 by Nisarg Upadhyay

In this article, we are going to learn how we can write a SQL query with space in the column name. Blanks spaces are restricted in the naming convention of the database object’s name and column name of the table. If you want to include the blanks space in the object name or column name, the query and application code must be written differently. You must be careful and precise while writing dynamic SQL queries. This article explains how we can handle object names and columns with blank space in SQL Server and MySQL.

Popular free SQL online compilers

August 9, 2021 by Hadi Fadlallah

This article will mention some of the most popular free SQL online compilers that help developers debug and test their SQL code without installing an SQL instance locally or buying one on the cloud.

Using Stored Procedures with Return Values

August 6, 2021 by Esat Erkec

In this article, we will learn how we can use a Stored Procedure with return values with all details.

How to write subqueries in SQL

August 3, 2021 by Hadi Fadlallah

This article briefly explains how to write a subquery in SQL by providing examples.

Understanding SQL Server DBCC DBREINDEX command and its usage

August 2, 2021 by Nisarg Upadhyay

In this article, I am going to explain the DBCC DBREINDEX statement, its syntax, and its usage. Additionally, I am also going to cover the differences between the DBCC REINDEX and ALTER INDEX statements.

How to calculate Subtotals in SQL Queries

July 30, 2021 by Esat Erkec

In this article, we will learn how to calculate and add a subtotal in SQL queries.

A deep dive into SQL Table Variables

July 28, 2021 by Esat Erkec

In this article, we will explore some secrets about SQL Table Variables.

File Validation in SQL Server with xp_fileexist

July 6, 2021 by Esat Erkec

In this article, we will explore the xp_fileexist extended stored procedure usage and other details. At the same time, we will take a look at alternative methods to this procedure.

An overview of the SQL Server ISNUMERIC function

July 2, 2021 by Hadi Fadlallah

This article gives an overview of the SQL Server ISNUMERIC built-in system function. It explains how to use this function, illustrates its limitations, and provides some alternatives.

An overview of the sp_helptext statement

June 28, 2021 by Nisarg Upadhyay

In this article, we are learning about the sp_helptext statement. I am going to show the various examples of the usage of it. I will also explain the two alternatives of the sp_helptext statement.

SQL GO command in SQL Server

May 18, 2021 by Daniel Calbimonte

Introduction

If you are using SQL Server and saw a GO command in a T-SQL script and you do not know what that GO is used for, this article is for you. In this article, we will explain what the SQL GO command is when to use it, and some tips about using it.

Learn SQL: How to prevent SQL Injection attacks

May 17, 2021 by Emil Drkusic

In the previous articles we’ve talked about SQL injection and dynamic SQL but we lacked an answer on how to prevent SQL injection attacks. Today we’ll do exactly that and show you one possible approach to how to do it. We’ll also mention other possible threats and approaches you could take.

Impact of SQL Variables on Performance

May 10, 2021 by Esat Erkec

In this article, we are going to learn how SQL variables negatively affect query performance and also examine the causes of this issue.

Dynamic Data Masking in Azure Synapse Analytics

April 23, 2021 by Gauri Mahajan

This article will take you through the process to apply Dynamic Data Masking on the dedicated SQL pool of Azure Synapse Analytics.

Working with parameters in the sp_executesql stored procedure

April 16, 2021 by Hadi Fadlallah

This article explains how to use the sp_executesql system stored procedure to run static and dynamic SQL queries and how to pass input and output parameters while using it.

Stairway to SQL essentials

April 7, 2021 by Prashanth Jayaram

SQL Essentials stairway series helps readers understand the most common database language SQL uses for data munging and data wrangling. SQL Essentials articles is a collection of SQL standards and best practices and help you take you in step closer to learn database query.

Learn SQL: Dynamic SQL

March 3, 2021 by Emil Drkusic

Dynamic SQL is a programming technique you can use to build SQL statements as textual strings and execute them later. This technique could prove to be useful in some cases and therefore it’s good to know we have it as an option. In today’s article, we’ll show how to create and execute dynamic SQL statements.