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

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

  • RE: LEN()

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • RE: Date Difference

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

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

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

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

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

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

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