BIT data type

Question

Post reply

BIT data type

Thomas.Kovarik

SSC Enthusiast

Points: 174
More actions
January 21, 2013 at 9:29 pm

#287837

Comments posted to this topic are about the item BIT data type
January 22, 2013 at 1:12 am

This was removed by the editor as SPAM

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

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

An easy one for the day. Looking at all the answers, it was quite obvious to find the correct one (the odd one out).

Posting the correct link:

http://msdn.microsoft.com/en-us/library/ms177603.aspx

Thanks!

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Dineshbabu Hall of Fame Points: 3220 More actions · Answer 2

Topic says BIT data type but explaination deals about ELSE (IF...ELSE). By seeing the question I expected something about NULL handling with BIT Data type.

Anyway easy one to start the day.

--
Dineshbabu
Desire to learn new things..

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 3

Nice, thank you for the question.

(title could have been IF..ELSE statement as the objective of the question is not exactly on the BIT data type, but how the IF statement is written to evaluate the value to produce the output).

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Thanks for the question.

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

sqlnaive SSCoach Points: 17437 More actions · Answer 5

sqlnaive

SSCoach

Points: 17437

January 22, 2013 at 12:21 am

#1579458

Nice question. 🙂

Sean Pearce SSCoach Points: 15999 More actions · Answer 6

Nice easy question. The question is all about whether setting a bit datatype to 'TRUE' evaluates to 1 or NULL. Easy to guess as the output would either be all or nothing.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

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

Nice easy question, thanks.

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

manik_anu SSCrazy Points: 2377 More actions · Answer 8

very basic thing... easy one ... 🙂

Manik
You cannot get to the top by sitting on your bottom.

demonfox SSCertifiable Points: 6289 More actions · Answer 9

Lokesh Vij (1/21/2013)
An easy one for the day. Looking at all the answers, it was quite obvious to find the correct one (the odd one out).
Posting the correct link:
http://msdn.microsoft.com/en-us/library/ms177603.aspx
Thanks!

+1

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

Yogeshwar Phull Default port Points: 1434 More actions · Answer 10

Yogeshwar Phull

Default port

Points: 1434

January 22, 2013 at 3:37 am

#1579514

Thanks for an easy one. +1

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 11

nice try.

keep growing.

always do your best 🙂

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

Thomas Abraham SSChampion Points: 10761 More actions · Answer 12

Nice effort and question. I hope you feel more a part of the community now. I know I did when I had my first question posted, and survived the resulting commentary. 🙂

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

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 13

(Bob Brown)

SSCrazy

Points: 2705

January 22, 2013 at 5:38 am

#1579578

Thanks for the question!