Derik Hammer

One Size Does Not Fit All

Today we have a guest editorial from Derik Hammer that reminds us that there isn't one solution that will fit all your solutions.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2018-04-06 (first published: 2014-07-16)

201 reads

A cryptic message, a book cipher hidden in art provenance records, and a trail...

A customer was trying to compare two tables and capture a state as a...

When I'm looking at a query, I bet it's bad if I see... a...

Comments posted to this topic are about the item BIT_COUNT II

Comments posted to this topic are about the item I Can't Make You Learn

Comments posted to this topic are about the item Why Your SQL Permissions Disappeared

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;