Question of the day

  • Comments posted to this topic are about the item Question of the day

  • Used these many times but had to read to make sure I get it right. Thanks for the question. +1

  • Nice question, thanks

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

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

  • nice and easy ..

    thanks

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

  • I am getting myself confused with some simple maths :crazy:

    Answer 1

    Coalesce can take more than two parameters, and IsNULL takes exactly two parameters

    97%

    Answer 5

    Coalesce takes exactly two parameters, and IsNULL takes more than two parameters

    6%

    Does this mean somebody selected these two options as an answer?

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • Easy One.. Thanks for the point.

    I think few days back had a discussion about data type precedence of COALESCE.

    --
    Dineshbabu
    Desire to learn new things..

  • Nice QtoD. (even though if it looks simple, it is not, makes you think.... 🙂 )

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

  • Easy Friday question, thanks!

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

  • This was removed by the editor as SPAM

  • Nice and straightforward way to end the week - thanks.

    Can't see there'll be much debate about this one!

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

  • Stuart Davies (1/25/2013)


    Can't see there'll be much debate about this one!

    I vehemently disagree.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • nice question... i am bit confusion about the point "The return type of COALESCE does depend on the data type precedence rules". can u explain any body?????

    Manikandan.ps

    Move fast as possible...................

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

  • manik123 (1/25/2013)


    i am bit confusion about the point "The return type of COALESCE does depend on the data type precedence rules". can u explain any body?????

    See http://msdn.microsoft.com/en-us/library/ms190309.aspx for the data type precedence - the rules that determine the return data type of any operation in SQL Server that combines different data types - except ISNULL, where the return type is always that of the first parameter and the rules of data type precedence don't apply.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

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

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