All About SQL

I am an IT Professional from the UK with a huge interest in MS technology especially SQL Server and Azure. During...

2015-03-25

309 reads

A Handy function

If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use...

2015-03-03

172 reads

Have you ever wanted to start a SQL trace (server-side trace!) from SQL agent and let it stop after X minutes...

2015-02-07

248 reads

There is no excerpt because this is a protected post.

2015-02-06

203 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...

Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...

Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...

Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas 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;