SQL This, Not That – Episode 2
When creating a table with a column that will hold the name of a stored procedure that feeds an EXEC...
2009-04-30
1,434 reads
Suggested Reading: Microsoft SQL Server 2008 Administration with Windows PowerShell
Suggested Reading: Microsoft SQL Server 2008 Administration with Windows PowerShell
My earliest forays into writing powershell for SQL Server found me...
2009-04-30
2,264 reads
SQLSaturday #15 is May 2nd, 2009 in Jacksonville
My friend Brian Knight is leading the 2nd annual SQLSaturday in Jacksonville on May 2nd. Right now it looks like...
2009-04-29
1,327 reads
SQL Saturday Atlanta Recap
I had a great time at SQL Saturday Atlanta last weekend. I drove from Orlando to Atlanta on Friday with...
2009-04-29
1,531 reads
RE: Career Development and Training by Lynn Pettis
Thank you, Lynn, for your previous post. I have reinforced in my first blog posting on SSC about certification as...
2009-04-29
1,772 reads
The #1 Secret to Building Your Skill Set is...
Self-Discipline
Yes, I've said it: self-discipline.
I'm reading a book called Disciplines of a Godly Man by R. Kent Hughes. Now...
2009-04-29
1,983 reads
The Industry’s Best IT Certification
The Best 10 IT Certification
Every IT Technology has the importance and positive values to use for the business.So the people...
2009-04-29
1,596 reads
Google G1 Update - Protecting the Screen
Well it didn't take long. On a conference call a couple weeks ago, trying to juggle the phone, the laptop,...
2009-04-29
1,787 reads
Starting Conversations - Part 3
If you haven't already, start with Part 1 and Part 2. In Part 2 I mentioned that I have hired...
2009-04-28
1,415 reads
European PASS Conference 2009 Has 254 Attendees
The 2009 European PASS Conference, which was held April 22-24, 2009, had 254 attendees from 22 different countries. In spite...
2009-04-28
1,625 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
Alamat Kontak Bank BCA KCP Surabaya WA {08218154393}
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
Alamat Kontak Bank BCA KCP Perak WA {08218154393}
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
Question of the Day
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