X on XMLA: iii. Basic DDL Functions in XMLA (Create, Alter, Delete)
XMLA can be used to manage the structure of your multidimensional databases. While many developers use Visual Studio (BIDS), to...
2012-04-10
724 reads
XMLA can be used to manage the structure of your multidimensional databases. While many developers use Visual Studio (BIDS), to...
2012-04-10
724 reads
If you happen to be in the area on April 21, 2012, join us at Madison Area Technical College – Truax...
2012-04-04
603 reads
The first tip I published discussed how to execute an Oracle procedure with no parameters. In this tip, I will...
2012-04-03
744 reads
Earlier this month I published a blog entry on this same subject. In honor of the local Minneapolis launch event,...
2012-03-28
704 reads
The second post in the XMLA series focuses on the basic structure of XMLA. At its heart, XMLA is XML. ...
2012-03-27
704 reads
I just wanted to plug two events that are free SQL Server training. First, Thomas LaRock (@sqlrockstar) and Jason Strate...
2012-03-20
589 reads
By now many of you have had the opportunity to hear or see something about the next release of SQL...
2012-03-08
677 reads
Originally posted: 3-4-2012 Welcome to a new blog series of tips related to Oracle with a focus on helping those...
2012-03-04
596 reads
As many of you may know, I am the Chair for the Minnesota SQL Server User Group aka PASSMN. I...
2012-02-22
595 reads
This past Tuesday, February 14, I was invited to discuss how technology can be used to help analyze data for...
2012-02-16
609 reads
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Comments posted to this topic are about the item Let's Talk Certifications
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