Overview of DML Operations – SQL Delete
This article on the SQL Delete is a part of the SQL essential series on key statements, functions and operations...
2018-12-03
379 reads
PowerSQL By Prashanth Jayaram
Overview of the SQL Insert statement
This article on the SQL Insert statement is part of a series on string manipulation functions, operators and techniques. The...
2018-10-26
387 reads
SQL Pivot and Unpivot relational operatots
In this article, we’ll walk-through the SQL Pivot and SQL Unpivot operators and how they can be useful to transpose...
2018-10-15
276 reads
Overview of the SQL Update statement
In this article, we’ll walk-through the SQL update statement to modify one or more existing rows in the table. After reading...
2018-10-08
311 reads
Overview of SQL UNION
This article will provide a deep dive into the SQL UNION operator, describing its many uses along with examples and...
2018-09-27
788 reads
Overview of SQL Joins in SQL Server
The ability to combine results from related rows from multiple tables is an important part of relational database system design. In SQL...
2018-09-19
641 reads
SQL Substring function in SQL Server
The requirement of data refactoring is very common and vital in data mining operations. In the previous article, you’ll learn...
2018-09-17
274 reads
SQL Server string functions for Data Munging (Wrangling)
In this article, you’ll learn the tips for getting started using SQL string functions for data munging with SQL Server....
2018-09-13
366 reads
Getting started with SQL Server Tools
This article is part of the SQL Server Tools series, aimed at giving you an idea of the available tools and techniques...
2018-09-04
652 reads
Experimenting SysTools SQL Database Repair Tool by SQL MVP Shashank
Author Bio: Shashank is a TechNet Wiki Ninja who loves to work on SQL Server. He lives in Mumbai and...
2018-08-24
358 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers