Forum Replies Created

Viewing 15 posts - 16 through 30 (of 234 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...

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

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

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

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

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

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

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

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

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

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

    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 😛

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

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

    March 11, 2013 at 8:25 am

    #1595583

  • RE: DATETIME - 3

    Thank you for a nice one question.

    March 11, 2013 at 2:55 am

    #1595413

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