Forum Replies Created

Viewing 15 posts - 241 through 255 (of 584 total)

  • RE: SQL Server Error Handling

    SQLRNNR (3/31/2013)


    Interesting, I can use that set option in SP1 of SQL 2012.

    Not having yet moved to SQL 2012, I had to wrote my own sp to do this. The...

  • RE: LEN()

    Nice question, on a seemingly simple, but not so, issue. Thanks!

  • RE: CASCADE - 2

    Thanks for the question Ron.

    I'm developing a bit of paranoia. Even when the question is easy for me, I figure that I am missing something.

    As Andy Grove said, only the...

  • RE: CASCADE - 1

    Dineshbabu (3/19/2013)


    I expected there will be some trickery work will be there.. But it's easy and staright forward question..

    I too looked for the trick. But, it's only easy if you...

  • RE: DATETIME - 4

    Thanks for the question Ron. I usually do the QOTD within ten minutes of rising in the morning. So, it helps when it's short. Or, as in this case, on...

  • RE: INNER JOIN

    Knew that none of the given answers was correct. So, just picked one to see what the"official" answer was. As others, most completely Hugo, have said, the query can return...

  • RE: DATETIME - 3

    As I post this, answer four has the lowest correct percentage of the four correct answers, an yet it is the only one without a valid alternative. Hmmmm ...

    Thanks Ron...

  • RE: SETTINGS - 1

    When I saw the question, I knew it must be Monday. "Oriented in space and time? Check."

    Thanks Ron for this, and your many other contributions.

  • RE: Updating the data in a table

    demonfox (2/28/2013)

    yes.. and I think , it would be same as this one

    ... (code removed for brevity) ...

    a simpler look 😛

    And, while not a great QOTD, this version would...

  • RE: OUTPUT - 1

    Thanks for the question Ron. Clever of you to have used the lower case 'w' to make the conspiracy minded believe this was yet another question on collation.

  • RE: Update with CASE statement

    Koen Verbeeck (2/18/2013)


    Spent 10 minutes looking for the catch, only to realize there wasn't one.

    +1 and since I just got up, I figured I was missing something. So, I clicked...

  • RE: Type conversions and Nulls

    ldorian81 (2/5/2013)


    I knew there was a trick to this one,

    really good question thanks 🙂

    Yes, I saw the NULL issue immediately, and then hit one of the checkboxes. Didn't even stop...

  • RE: Date Difference

    Nice question. Simple, but with a good point. Thank you Siddharth.

  • RE: Computed column

    L' Eomot Inversé (1/31/2013)


    It's quite clear that T-SQL is Turing Complete except in so far as it can have only finite resources, so there can be no argument that any...

  • RE: BIT Primary Key

    Nice one. I noticed the bit data type, but wasn't even thinking about binary vs decimal. Doh.

    And I even told someone today the line I stole from (sorry can't remember...

Viewing 15 posts - 241 through 255 (of 584 total)