The Big Bit

Question

Post reply

The Big Bit

Steve Jones - SSC Editor

SSC Guru

Points: 736297
More actions
July 18, 2015 at 12:50 pm

#74518

Comments posted to this topic are about the item The Big Bit
July 20, 2015 at 4:06 am

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

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

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 1

Michael Riemer

SSCertifiable

Points: 5190

July 20, 2015 at 2:01 am

#1813590

a lovely easy start to the week- thanks.

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

Easy ones are nice every once in a while. It does illustrate a good point.

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 3

There's just one exception to the rule: The string FALSE will return 0 when converted to bit.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

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

Revenant

SSC-Forever

Points: 42467

July 20, 2015 at 10:15 am

#1813694

Very interesting - thanks, Steve!

chgn01 SSCarpal Tunnel Points: 4358 More actions · Answer 5

How about BIT = 0&1|1%2; '' ; & ....?

--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius

Hany Helmy SSChampion Points: 13921 More actions · Answer 6

Good 2 know, thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 7

Luis Cazares (7/20/2015)
There's just one exception to the rule: The string FALSE will return 0 when converted to bit.

I forgot about this. Thanks.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 8

Easy one, thanks.

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