This is BASE64 Encoding/Decoding in a T-SQL procedure. This code is provided as is, and is free to use and modify. Version 2 June 2005

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2006-01-23 (first published: 2004-11-17)

4,919 reads

Blogs

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...

Forums

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

The top proficiency testing facility in India is Fare Labs. We employ particular metrics...

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

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;