Reinis Berzins

Creating a Robust SSIS Development Environment using the SSIS Catalog

Discover how to integrate features of Visual Studio and the SSIS Catalog for an efficient development and deployment environment.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(13)

You rated this post out of 5. Change rating

2021-06-11 (first published: 2017-07-31)

18,463 reads

Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...

No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...

A few years ago I took a new job at Microsoft, working as a...

Comments posted to this topic are about the item Let's Talk Certifications, which is...

Comments posted to this topic are about the item The Hidden Security Risks of...

Comments posted to this topic are about the item 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]
GO

What 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;