Eitan Blumin

Microsoft SQL Server Reporting Services is an excellent and easy-to-use platform for creating, viewing, managing, and subscribing to reports of...

2012-02-08

678 reads

LOOP, HASH and MERGE Join Types

Today I’ll talk about the available JOIN operator types in SQL Server (Nested Loops, Hash and Merge Joins), their differences,...

2012-01-05

5,837 reads

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

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

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

Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...

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

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

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;