BIT data type

  • Comments posted to this topic are about the item BIT data type

  • 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

  • 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..

  • 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.

  • 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

  • Nice question. 🙂

  • 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]

  • This was removed by the editor as SPAM

  • 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

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

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

  • 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:

  • Thanks for an easy one. +1

  • nice try.

    keep growing.

    always do your best 🙂

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

  • 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

  • Thanks for the question!

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

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