Forum Replies Created

Viewing 15 posts - 46 through 60 (of 121 total)

  • RE: What will be the output message?

    When I read through the question, I saw what looks like eight extra apostrophes, not just the one in the pronunciation helper for "Grisham". However, the extra apostrophes in Dean...

  • RE: In The Beginning

    webrunner (11/25/2014)


    "3114 B.C. is the start of the Mayan calendar."

    I wonder whether the Mayans used "May-SQL" 😀

    - webrunner

    +1 :w00t:

  • RE: In The Beginning

    Mike Hays (11/25/2014)


    Maybe its me. Once I had BASIC loaded on my Altair 8800, I can not seem to remember anything before that (like my wedding, children being born,...

  • RE: In The Beginning

    Thanks for the nice, easy question, Sean.

    Another good option for the list of choices would have 0001-01-01, which is the earliest date for a DateTime2 data type.

    I thought that perhaps...

  • RE: Real World T-SQL Tricks

    Most of my work is on Sybase (ASE and IQ), so I don't get to use the more recent SQL Server functionality as much as I would like. I did...

  • RE: Table valued parameter

    Good question, Igor, and very interesting. Thanks!

  • RE: Trace Flags

    Nice question, Sourav, thanks.

  • RE: Update Identity column

    Great question, Igor, thanks.

  • RE: TSQL "where - 101"

    Nice, easy question, Stuart. I also noticed the case difference and thought I would mention it in my reply if nobody else did, but of course I wasn't the first...

  • RE: Logical Query Processing order

    I noticed that 1 and 4 were identical, so I figured they must both be wrong. I also eliminated the ones that included TOP before ORDER BY, because that would...

  • RE: The Import Wizard

    TomThomson (11/6/2014)


    Good question.

    It raises an issue about the quality of this wizard: why on earth doesn't it read metadata for the target table and set lengths accordingly? It...

  • RE: Fun with RAND()

    Nice question, Dave, and a good explanation. Thanks!

  • RE: Formatted output

    Thanks for a good question, Anju.

  • RE: Primary key vs Unique key

    davoscollective (10/28/2014)


    Primary key creates a clustered index by default, only if there is no existing clustered index. It's often the case that you want a clustered index on something other...

  • RE: FIRST_VALUE

    Excellent question. Thanks, Steve.

Viewing 15 posts - 46 through 60 (of 121 total)