Cláudio Tereso

I'm from the Spectrum generation. I started copying programs from books so I could play them when I wasn't even 10 years old. From there, programming my own programs was a leap. As a teenager I did programming work for university students and when I started working it was in programming.

My interests changed and I entered the area of databases, SQL programming and network administration, areas in which I obtained several Microsoft certifications. Along the way I also published the books, by the Portuguese Editor FCA, "Local Networks in Windows 98 & 95 - Complete Course" and the corresponding update for the hated Windows Me.

I now work with SQL Server, Power BI, Azure and related Microsoft technology. I'm also having some fun with Python.
  • Interests: orienteering and all things mountain :)

All authors

All authors

Blogs

Learn about Modern Microsoft Apps in San Diego

By

I wrote about learning today for the editorial: I Can’t Make You Learn. I...

How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps

By

Fabric has CI/CD built in, but if you've tried to use it for database...

A New Word: Attriage

By

attriage – n. the state of having lost all control over how you feel...

Read the latest Blogs

Forums

Getting results from a Procedure to join to a query

By bswhipp

I have a need to execute a stored procedure and return the results to...

Upgrade 2016 Standard to 2022 Express

By pdanes

Title pretty much says it all - can this be done? I've tried several...

BIT_COUNT II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BIT_COUNT II

Visit the forum

Question of the Day

BIT_COUNT II

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data: 

UserID  UserPermissions
15
23
37
4       NULL
What is returned when I run this code: 
select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;

See possible answers