BIT Primary Key

Question

BIT Primary Key

Viewing 12 posts - 31 through 41 (of 41 total)

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

Jason Wolfkill SSCrazy Eights Points: 9832 More actions · Answer 1

Hugo Kornelis (1/29/2013)
wolfkillj (1/29/2013)
(And yes, I know I spelled DR0P TABLE with a zero instead of an "O". In posting on this forum, I have discovered the my employer seems to have some kind of security filter that blocks outgoing web traffic that includes certain SQL statements. If I spelled DR0P TABLE correctly, that filter would catch this post and return a message that my machine is unable to communicate with the server.)
*lol* This sounds like someone read the famous "Bobby Tables" cartoon[/url] - and then completely misunderstood it! *lol*

"Little Bobby Tables" is very well known around here, so I don't think that's the problem. Plus, the filter catches outgoing content. The filter only seems to catch certain T-SQL statements, though. I'll have to ask the sysops or infosec guys about this next time I'm in their end of the building.

Jason Wolfkill

mtassin SSC-Insane Points: 23099 More actions · Answer 2

Thanks for the question. Glad I was right on it.

Also thanks to demonfox and others for the further details into the refresher on the bit data type

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

Olga B SSCommitted Points: 1529 More actions · Answer 3

Nice easy question, with a bonus discussion about one-row tables. 🙂

On the second thought, the table in the question allows 0 or 1 rows, while Hugo's example ensures that the table, once the first row is inserted, will always have exactly 1 row.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 4

Nice one. I noticed the bit data type, but wasn't even thinking about binary vs decimal. Doh.

And I even told someone today the line I stole from (sorry can't remember at the moment whoit belongs to) someone's sig line: "There are 10 types of people ...." Need more rest. 🙂

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 5

PChiragS

SSCarpal Tunnel

Points: 4965

January 29, 2013 at 9:04 pm

#1582452

Nice Question..

Thanks..

Narud SSCrazy Points: 2837 More actions · Answer 6

Easy one. And greats Hugo Cornelis's contributions.

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 7

Hardy21

SSCrazy Eights

Points: 9708

January 31, 2013 at 2:52 pm

#1583202

Nice easy one..

Thanks

@Cassie SSC Eights! Points: 890 More actions · Answer 8

@Cassie

SSC Eights!

Points: 890

February 1, 2013 at 2:58 pm

#1583602

Great, sneaky question.

😛

Thanks a lot.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Lokesh Vij (1/28/2013)
Easy question for the day!
I agree with the explanation by "demonfox", here is the BOL link for BIT datatype:
http://msdn.microsoft.com/en-us/library/ms177603.aspx
It clearly says "any non-zero value will be converted to 1". I could not find the concept of the number being converted into binary and than getting truncated. Can anyone pour some light on what is happening internally?

+1

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events