Post reply

Power of implicit conversion

  • September 25, 2011 at 12:29 am

    #245405

    Comments posted to this topic are about the item Power of implicit conversion

  • September 25, 2011 at 1:30 pm

    #1386239

    An Interesting Question!

  • September 26, 2011 at 12:46 am

    #1386290

    Easy, but interesting. Good way to start a Monday.

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

  • September 26, 2011 at 1:12 am

    #1386302

    Thank you for the question.

    Regards,

    Iulian

  • September 26, 2011 at 1:49 am

    #1386311

    Excellent QOTD.

  • September 26, 2011 at 2:04 am

    #1386313

    This question and the coffee help wake me up this morning - thanks

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • September 26, 2011 at 2:44 am

    #1386320

    Good question - shame there weren't more possible answers given, I only had to look at the first two, and would probably have got at least one of the others wrong if I'd had to guess at them!

  • September 26, 2011 at 3:14 am

    #1386331

    Toreador (9/26/2011)

    Good question - shame there weren't more possible answers given, I only had to look at the first two, and would probably have got at least one of the others wrong if I'd had to guess at them!

    Or, you could have just looked at "C" and saw that '2' + '3' + 1 = 24 and none of the other possible answers had 24 as the answer. That excluded all others without even having to calculate anything else.

  • September 26, 2011 at 5:28 am

    #1386384

    Great question.

    The precedence of operators, in that case, will make all the difference.

    Since it's math, if we use parenthesis, we'll get a different result as expected.

    SELECT '2' + '3' * 1 -- = 5

    GO

    SELECT ('2' + '3') * 1 -- = 23

    GO

    A good way to start the week. 😉

    Best regards,

    Best regards,

    Andre Guerreiro Neto

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

  • September 26, 2011 at 5:38 am

    #1386392

    Good question. Thanks for making me think on a Monday morning.

    http://brittcluff.blogspot.com/

  • September 26, 2011 at 5:54 am

    #1386403

    Excellent! Just the right amount of grey cell stimulation for an early Monday morning. Thanks.

    Great example of taking two simple things you "know" (precedence and conversion) and synthesizing them into something greater than the two halves.

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

  • September 26, 2011 at 6:42 am

    #1386430

    good question!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • September 26, 2011 at 7:29 am

    #1386479

    I had to look at it for a minute, but I noodled it out. Good question, thanks.

  • September 26, 2011 at 7:50 am

    #1386499

    Good question for a Monday.

  • September 26, 2011 at 8:42 am

    #1386552

    That was an easy one... thanks!

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

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