Parsing T-SQL – The easy way
UPDATE 2012-09-12 : For my latest adventures with TSQL Parsers please see this post
Every once in a while, I hit an issue...
2012-03-13
11,096 reads
T-SQL Tuesday #28 – Jack of all Trades, Master of None
It’s that time of the month again, T-SQL Tuesday Tuesday. This month Argenis Fernandez, MCM, and big round SQL teddy-bear...
2012-03-13
1,174 reads
T-SQL Tuesday #028 – Jack of All Trades, Master of None?
This month, Argenis Fernandez (blog, @DBArgenis) is hosting our monthly T-SQL Tuesday, and he wants to know: Are you specialized?...
2012-03-13
952 reads
T-SQL Tuesday #028 – Jack of All Trades, Master of None?
Every month the folks of the SQL Server community get together for a virtual block party of sorts called T-SQL...
2012-03-13
699 reads
T-SQL Tuesday #028 – Jack of All Trades ie Integration Specialist
Argenis Fernandez (blog | twitter) is hosting the latest T-SQL Tuesday and asking about specialization. For the earlier part of my career I was doing application development while really...
2012-03-13
24 reads
T-SQL Tuesday #028 – Jack of All Trades ie Integration Specialist
Argenis Fernandez (blog | twitter) is hosting the latest T-SQL Tuesday and asking about specialization.
For the earlier part of my career...
2012-03-13
698 reads
Command Prompt connectivity –U option
When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows...
2012-03-13
540 reads
T-SQL Tuesday #028 – Jack of All Trades, Master of None?
It's T-SQL Tuesday again, and this month Argenis Fernandez (@DBArgenis/Blog) is hosting with the topic of "Jack of All Trades,...
2012-03-13
955 reads
What SQL2012 Feature Are You Excited About the Most?
Last week the internet went crazy with the news of super cool new stuff for techies to play with.
If you’re...
2012-03-13
898 reads
SQL Server 2012 Books
SQL Server 2012 was released to manufacturing last week, you can download it from MSDN if you have subscription or...
2012-03-13
2,185 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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