Forum Replies Created

Viewing 15 posts - 616 through 630 (of 652 total)

  • RE: INT and SMALLINT

    Easy for a VB6 programmer 🙂

    If one of the options had been 1 or -1 or even 32767 I might have got it wrong though!

    December 15, 2009 at 6:57 am

    #1092480

  • RE: SELECT @local_variable

    I guessed rigtht, but only because I knew it had to begin with 'Question' and there was only one answer that did that. If there'd been an option for 'Question...

    December 14, 2009 at 3:53 am

    #1091835

  • RE: Clustered Index Internals

    "Dropping a rebuilding a clustered index on a partition scheme will move disk to other drives."

    I have no idea what this means, and the answer doesn't seem to mention it.

    Can...

    December 9, 2009 at 2:19 am

    #1089687

  • RE: Fun with Scale and Precision

    sknox (12/4/2009)

    Steve Eckhart (12/4/2009)

    select cast(1.67574 as decimal(38,10)) = 1.675400000 which has precision 6 and scale 10, right?

    and

    select cast(10000 as decimal(38,10)) = 10000.0000000000 which has precision 1 and scale 10, right?

    wrong,...

    December 8, 2009 at 9:35 am

    #1089338

  • RE: T-SQL

    Lynn Pettis (11/17/2009)

    You know, I haven't tried writing a QotD. Have you?

    Ah, that old chestnut.

    I've never been Prime Minister either, but I still get to say what I think...

    November 17, 2009 at 9:30 am

    #1080354

  • RE: T-SQL

    Lynn Pettis (11/17/2009)

    Yes, getdate() and getutcdate() return different values, just look at what they return when you run them. However both functions return values that are equivelent to each...

    November 17, 2009 at 9:10 am

    #1080333

  • RE: T-SQL

    bitbucket-25253 (11/17/2009)

    Lynn Pettis has explained in great detail the reason the times are the same, and as a matter of fact has explained the reasoning better than I could have....

    November 17, 2009 at 8:16 am

    #1080289

  • RE: T-SQL

    Lynn Pettis (11/17/2009)

    Everyone is looking at the values, yes, they are "different", but both represent the same time. One is local, the other UTC.

    If that is the reasoning then...

    November 17, 2009 at 6:53 am

    #1080206

  • RE: T-SQL

    Thought about answering True, because for me (in the UK) they will return the same value, but figured that the author was probably in the US so the answer was...

    November 17, 2009 at 2:53 am

    #1080115

  • RE: DateTime Trick

    Surely date formatting should normally be part of the presentation layer? I always return the whole datetime value and format it on the client, using their regional settings etc.

    October 27, 2009 at 4:08 am

    #1071096

  • RE: Varchar or Char?

    Thanks Hugo 🙂

    October 16, 2009 at 7:53 am

    #1066883

  • RE: Varchar or Char?

    The question asks which is more efficient.

    The explanation describes which uses least space, which is not the same thing as most efficient.

    I suspect that the answer is correct, but would...

    October 16, 2009 at 5:20 am

    #1066813

  • RE: AND & OR

    archie flockhart (10/14/2009)

    Not only a trick question, but one that is possible to get right by getting the reasoning all wrong...

    If you don't know that AND and OR operate bitwise...

    October 14, 2009 at 8:48 am

    #1065734

  • RE: IN Operator

    Hugo Kornelis (10/2/2009)

    A very unusual pattern, as LIKE is intended to be used with wildcard characters, but syntactically valid.

    We use it widely, where searches which can be either on exact...

    October 2, 2009 at 4:25 am

    #1060833

  • RE: IN Operator

    Hugo Kornelis (10/2/2009)

    That standard dictates that when strings of unequal length are compared, the shorter string is first padded with spaces until it matches the length of the longer string,...

    October 2, 2009 at 2:41 am

    #1060813

Viewing 15 posts - 616 through 630 (of 652 total)