DML

Behind the scenes of the SQL Delete Statement

January 31, 2022 by Esat Erkec

In this article, we will explore the details of what happens behind the scenes when a SQL delete statement is executed.

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.

SQL UPDATE syntax explained

July 10, 2020 by Bojan Petrovic

This article will get you familiar with the SQL UPDATE syntax and demonstrate how this statement can be used for modifying data using T-SQL. Data modification side of DML language in T-SQL includes three statements used for modifying data in SQL Server and those are: INSERT, UPDATE, and DELETE. The focus here will be on the UPDATE statement explicitly.

What is SQL in SQL Server?

December 5, 2018 by Prashanth Jayaram

What is SQL, in the context of SQL Server, is a common question asked by beginners. This article is meant to answer that question, while providing some history, context and an overview of the fundamentals of the language Read more »

Overview of the SQL Delete statement

October 25, 2018 by Prashanth Jayaram

This article on the SQL Delete is a part of the SQL essential series on key statements, functions and operations in SQL Server.

How to set up a DDL and DML SQL Server database transactional replication solution

August 22, 2018 by Prashanth Jayaram

In the article How to setup SQL Server database replication for reporting Server we discussed all about setting up a simple SQL Server transactional replication environment. In this article, we’ll simulate a more robust system that replicates faster and includes both DDL and DML statements. We’ll walk-through the steps to setup a dynamic transactional replication.