Today John Sterrett (blog | twitter) and I are announcing a new SQL PASS Virtual Chapter dedicated to High Availability and Disaster...
2014-02-10 (first published: 2014-02-04)
1,401 reads
Place Your Bets All bets on the table please. This is the last call for bets, no new bets will be allowed. This marks the 51st invitation for TSQL...
2014-02-04
8 reads
Place Your Bets
All bets on the table please. This is the last call for bets, no new bets will be...
2014-02-07 (first published: 2014-02-04)
2,305 reads
I suspect most DBAs have a script in their T-SQL toolbelt which scripts out database permissions for a specific user...
2014-02-04
1,118 reads
Have you ever had an error when using a SQL Server Proxy Account? I ran across a misleading error. Let...
2014-02-10 (first published: 2014-02-04)
1,890 reads
SQL Intersection is coming to Orlando in April, along with the rest of the Dev Intersection events the week of...
2014-02-07 (first published: 2014-02-04)
1,581 reads
I have had a few questions like this: “I was wondering if there is a reason the vendor/broker/head hunter forces...
2014-02-04
785 reads
Since I took the leap last year and submitted to talk at SQL Saturday, I’ve come to enjoy the challenge that...
2014-02-04
622 reads
Wondering how to stay informed and entertained during the 2014 Winter Olympics? Here are 20 Twitter accounts to get you...
2014-02-04
582 reads
The Problem: A legacy table contains amounts and a char column indicating whether the amount is a credit or a...
2014-02-11 (first published: 2014-02-04)
3,110 reads
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
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] 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