Bitwise OR

Question

Post reply

Bitwise OR

Junior Galvão - MVP

SSCertifiable

Points: 6974
More actions
February 6, 2016 at 11:12 am

#307703

Comments posted to this topic are about the item Bitwise OR
February 7, 2016 at 11:03 pm

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Carlo Romagnano SSC-Insane Points: 22747 More actions · Answer 1

Carlo Romagnano

SSC-Insane

Points: 22747

February 7, 2016 at 4:04 am

#1857023

Extremely simple for C programmer!!!

Thanks

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

Yup, it definitely goes back a couple of years. Do I see a question series coming?

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

david.gugg SSCertifiable Points: 6137 More actions · Answer 3

Does anyone have any real-world examples of using bitwise functions in SQL Server? I've never used them before, but maybe there were times I could/should have and just didn't know enough about them.

Be still, and know that I am God - Psalm 46:10

DonlSimpson SSCertifiable Points: 7043 More actions · Answer 4

The whole table and column thing is a bit of overkill. You get the same result with:

select 250 | 255

Don Simpson

I'm not sure about Heisenberg.

bgodick SSC-Addicted Points: 459 More actions · Answer 5

I use bitwise operators occasionally, but moving towards using XML instead.

Still enjoy bitwise logic.

Thanks for the question.

DonlSimpson SSCertifiable Points: 7043 More actions · Answer 6

david.gugg (2/8/2016)
Does anyone have any real-world examples of using bitwise functions in SQL Server? I've never used them before, but maybe there were times I could/should have and just didn't know enough about them.

Not a lot of call (that I've ever seen) for them in query language. They're useful for writing operating systems and compilers, and when you're in a tight space like an embedded system. They are also useful for RDD (resumé driven development).

Don Simpson

I'm not sure about Heisenberg.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

I've seen it done to control flow through a set of rows, but that's about it. I've not had to implement it anywhere.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Revenant SSC-Forever Points: 42467 More actions · Answer 8

Revenant

SSC-Forever

Points: 42467

February 8, 2016 at 10:57 am

#1857187

Simple and neat - thanks, Junior!

Junior Galvão - MVP SSCertifiable Points: 6974 More actions · Answer 9

Junior Galvão - MVP

SSCertifiable

Points: 6974

February 10, 2016 at 4:21 am

#1857630

Thanks.

Junior Galvão - MVP SSCertifiable Points: 6974 More actions · Answer 10

Junior Galvão - MVP

SSCertifiable

Points: 6974

February 10, 2016 at 4:22 am

#1857631

Thansk.

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 11

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

TomThomson SSC Guru Points: 104773 More actions · Answer 12

Nice question, but the explanation is little sloppy; as the columns are ints, their binary representations each have 32 bits, not the 16 povided i teh explnation. Of course the missing bits re all zero, but still ...

Tom

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 13

A new week-end question but as Carlo noticed it , an easy one for programmers in C# ( or more generally C ).

Thanks for it.

Bitwise OR

Cookies on SQLServerCentral