Forum Replies Created

Viewing 15 posts - 16 through 30 (of 235 total)

  • RE: Timestamps

    wolfkillj (5/6/2013)

    Good question - I appreciate the QotDs that demonstrate quirky behavior.

    It bears mention that Microsoft has slated the "timestamp" syntax for deprecation in favor of "rowversion" as of...


    See, understand, learn, try, use efficient
    © Dr.Plch

    May 6, 2013 at 9:37 am

    #1612667

  • RE: Timestamps

    OCTom (5/6/2013)

    Hugo Kornelis (5/6/2013)

    Good question, thanks for submitting, Honza! I agree that it was clear enough that the code was supposed to be run as a single batch.

    To the person...


    See, understand, learn, try, use efficient
    © Dr.Plch

    May 6, 2013 at 8:01 am

    #1612641

  • RE: Timestamps

    Hugo Kornelis (5/6/2013)

    Good question, thanks for submitting, Honza! I agree that it was clear enough that the code was supposed to be run as a single batch.

    To the person posting...


    See, understand, learn, try, use efficient
    © Dr.Plch

    May 6, 2013 at 2:33 am

    #1612549

  • RE: Timestamps

    Carlo Romagnano (5/6/2013)

    The question states the batch in the very begining, there are no batch separators, and answers contain "not run due to previous errors". I think it's enough.

    +1

    😀

    Good qotd,...


    See, understand, learn, try, use efficient
    © Dr.Plch

    May 6, 2013 at 1:53 am

    #1612539

  • RE: Timestamps

    Evgeny (5/5/2013)

    Author should emphasize that it will be one batch. It will be too many wrong answers.

    The question states the batch in the very beggining, there are no batch...


    See, understand, learn, try, use efficient
    © Dr.Plch

    May 5, 2013 at 11:59 pm

    #1612519

  • RE: Timestamps

    hany.helmy (5/5/2013)

    I think the answer is wrong as statement #7 runs succesfully and returns 0 rows & also statements #8 run succesfully and didn`t fail for any reason!!

    Any explanation dear...


    See, understand, learn, try, use efficient
    © Dr.Plch

    May 5, 2013 at 11:08 am

    #1612474

  • RE: Sum and Count

    John Mitchell-245523 (4/18/2013)

    To generalise, if you have n tables Table1, Table2, ... , Tablen where for each value of k Tablek has k rows populated with values 1,2,...,k:

    The COUNT is...


    See, understand, learn, try, use efficient
    © Dr.Plch

    April 18, 2013 at 7:40 am

    #1607754

  • RE: Sum and Count

    Danny Ocean (4/17/2013)

    Kapil, Cross join means Cartesian product. When query have multiple joins, it solve it from left to right. So first cross join take place between table #T1...


    See, understand, learn, try, use efficient
    © Dr.Plch

    April 18, 2013 at 4:53 am

    #1607634

  • RE: INNER JOIN

    Kingston Dhasian (3/12/2013)

    mtassin (3/12/2013)

    I want to give my point back...

    :w00t:

    Normally people ask for points, I think its first time somebody wants to give the points back.

    And nobody asks points back...


    See, understand, learn, try, use efficient
    © Dr.Plch

    March 12, 2013 at 9:00 am

    #1596067

  • RE: INNER JOIN

    kapil_kk (3/12/2013)

    Hi all,

    Actually I read an article with a name Difference between Datetime and Datetime2 and surprised with the functioning of that so then I think of implementing that...


    See, understand, learn, try, use efficient
    © Dr.Plch

    March 12, 2013 at 7:04 am

    #1595975

  • RE: INNER JOIN

    vk-kirov (3/12/2013)

    Evgeny Garaev (3/12/2013)

    Right answer is wrong in this case. Beacause some rows could be returned. This query will prove my words:

    Very good script, although it produces a huge amount...


    See, understand, learn, try, use efficient
    © Dr.Plch

    March 12, 2013 at 3:51 am

    #1595873

  • RE: INNER JOIN

    The No rows answer is a subset of Matching rows answer where number of matching rows is zero 😛


    See, understand, learn, try, use efficient
    © Dr.Plch

    March 12, 2013 at 2:27 am

    #1595841

  • RE: DATETIME - 3

    wolfkillj (3/11/2013)

    I think Microsoft made its explanation of how the cutoff year functions more confusing by using the word "century". In my mind, and I suspect many others think the...


    See, understand, learn, try, use efficient
    © Dr.Plch

    March 11, 2013 at 10:27 am

    #1595656

  • RE: DATETIME - 3

    Hugo Kornelis (3/11/2013)

    Dave62 (3/11/2013)

    I'm thinking about including a question like this in an interviewing process.

    I don't agree. I happened to know this one because I was already using SQL Server...


    See, understand, learn, try, use efficient
    © Dr.Plch

    March 11, 2013 at 8:25 am

    #1595583

  • RE: DATETIME - 3

    Thank you for a nice one question.


    See, understand, learn, try, use efficient
    © Dr.Plch

    March 11, 2013 at 2:55 am

    #1595413

Viewing 15 posts - 16 through 30 (of 235 total)