Post reply

BIT Conversions

  • August 13, 2012 at 9:49 pm

    #265828

    Comments posted to this topic are about the item BIT Conversions

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • August 14, 2012 at 1:23 am

    #1525371

    Nice question. Surprised at the number selecting '0' as an answer though. 32% presently.

  • August 14, 2012 at 2:06 am

    #1525384

    Ack! I can explain why the 32%.

    I read the question and thought the trick was about the numbers that weren't 1 or 0 and went ahead and ticked all the boxes knowing they would all be inserted.

    ... but not all as True.

    Doh!

    My fault for not answering it carefully.

  • August 14, 2012 at 2:46 am

    This was removed by the editor as SPAM

  • August 14, 2012 at 2:58 am

    #1525401

    Doh!

    Good question, my bad for missing the as True/ 1 part. I knew they would all insert correctly...

    Must remember to read question after having coffee!

    Rodders...

  • August 14, 2012 at 4:12 am

    #1525416

    I was very careful with this one. Have been burnt too many times by not reading the question closely. Great question Wayne!

  • August 14, 2012 at 4:13 am

    #1525419

    Good one. Once again I fell right into the trap. Must remember to RTFQ / RTFS (Read the **** Question / Statement)

  • August 14, 2012 at 4:59 am

    #1525426

    Excellent question, Wayne.

    Thank you.

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • August 14, 2012 at 5:47 am

    #1525435

    Good question.

    A lot of careless readers around today - 31% (about 80) so far have picked 0, and I suspect the number of those who picked that for some other reason that having misread the question is very small indeed.

    Tom

  • August 14, 2012 at 5:47 am

    #1525437

    Good question, my bad is I just ignored 1 so I checked only -1 and 25 I missed out 1 🙂

  • August 14, 2012 at 5:59 am

    #1525443

    ..although I have been wrong,

    Good question!

  • August 14, 2012 at 6:41 am

    #1525465

    I almost fell prey to the wording of the question, but after reading it twice I realized my original answers were incorrect. Thank you for the great question.


    Everything is awesome!

  • August 14, 2012 at 6:43 am

    #1525470

    Excellent question. I particularly like questions, like this one, that highlight areas where the behavior is not as one might think, or is different than you might find in other languages. These are the gotchas that you have to know. Thanks!

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

  • August 14, 2012 at 6:49 am

    #1525474

    Good back to basics question... I'm glad I had my morning coffee first or I would have missed the 1/True bit. 🙂


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

  • August 14, 2012 at 7:33 am

    #1525504

    davoscollective (8/14/2012)

    Ack! I can explain why the 32%.

    I read the question and thought the trick was about the numbers that weren't 1 or 0 and went ahead and ticked all the boxes knowing they would all be inserted.

    ... but not all as True.

    Doh!

    My fault for not answering it carefully.

    +1

    I should know better than to answer before my first cup of coffee...

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

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