SQLStudies

My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...

2012-09-02

4,118 reads

At Startup SSMS setting

I came across this handy dandy little setting earlier this year. It was well hidden from me, by which I...

2012-08-27

663 reads

In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and...

2012-08-20

1,344 reads

“Don’t aim to have others like you; aim to have them respect you.” –...

Many years ago, before I joined Oracle, I was working on a major modernisation...

If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

WhatsApp: 0817839777 Jl. Brigjen Jl. Slamet Riyadi No.3, Kauman, Kec. Ps. Kliwon, Kota Surakarta,...

WhatsApp: 0817839777 Jl. Jend. Sudirman No.391 A, Brubahan, Purwanegara, Kec. Purwokerto Tim., Kabupaten Banyumas,...

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

UserID  UserPermissions
15
23
37

What is returned when I run this code:

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