Upgrading your skills from SQL 2005 to SQL 2008......
Greetings, ALL:
As more and more companies get on board and begin to adapt SQL Server 2008, what is the best...
2009-08-13
679 reads
Greetings, ALL:
As more and more companies get on board and begin to adapt SQL Server 2008, what is the best...
2009-08-13
679 reads
If you're not familiar with the reference, it comes from the movie Madagascar and the subsequent sequel and TV series...
2009-08-13
13,871 reads
Well, actually, these are the guidelines for submitting anything to SQLPASS, but it includes the guidelines for SQL Server Standard....
2009-08-13
1,171 reads
Well I spent most of this past Saturday upgrading my Laptop to Windows 7 Ultimate, which I have to say...
2009-08-13
753 reads
In a previous blog post, I began writing about how one might start a career as a database professional, and...
2009-08-13
617 reads
I guess I did a good job, with all 3s and 4s in my eval (meaning good and great) for...
2009-08-13
788 reads
One of the reasons that I think the PASS Summit fits well in Seattle is the support that they get...
2009-08-13
920 reads
We’ve just posted our core guidelines for technical content on sqlpass.org. The short story is there are three main ways...
2009-08-12
875 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-08-12
417 reads
For the one or two you that are not reading Buck Woody’s blog (and why aren’t you), you may not...
2009-08-12
704 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
Comments posted to this topic are about the item BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers