Question of the Day

BIT_COUNT I

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

UserID  UserPermissions
15
23
37

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 3;