Forum Replies Created

Viewing 15 posts - 121 through 135 (of 143 total)

  • RE: NULL

    Stewart "Arturius" Campbell (8/15/2012)


    Good back-to-basics question, thanks.

    However, as others have stated, the explanation is lacking a wee bit.

    Is a wee bit an eighth of a wee byte?

  • RE: ISNULL

    Even though I knew the answer without thinking about it, I made sure I thought about it, if you see what I mean. Sometimes, making you check up on...

  • RE: Commenting in Dynamic query

    L' Eomot Inversé (8/3/2012)


    Now why on earth anyone would want to put comments in dynamic SQL is beyond me. Its hard enough getting all the little ' right and to...

  • RE: Stack Ranking

    marlon.seton (7/24/2012)


    mtucker-732014 (7/19/2012)


    If you did have a group of people to begin with that had people who were 1 and 2, after you had weeded them out you would then...

  • RE: Stack Ranking

    mtucker-732014 (7/19/2012)


    If you did have a group of people to begin with that had people who were 1 and 2, after you had weeded them out you would then be...

  • RE: Time Zones

    Mad Myche (7/17/2012)


    a perfect instance would be the State of Michigan, which has 75000 people an hour behind the rest of the state

    What? What?? How did you get to...

  • RE: Password Help

    It's so much easier to use long and intricate passwords if you can type.

  • RE: INTERSECT 2

    Richard Warr (6/19/2012)


    All looked good to me - thanks for the question!

    Any ideas on the performance differences between the INTERSECT and INNER JOIN methods?

    I suspect the explain plans and performance...

  • RE: Interns

    Carla Wilson-484785 (6/8/2012)


    I would guess that the unpaid intern scenario got a foothold a few years ago, when college grads just could not get a job when they graduated, and...

  • RE: DateTime Puzzle

    What I find more disturbing than this reliance on implicit conversion and thinking of a DATETIME value being held as a float is the reference to 12.00 AM. Surely...

  • RE: Sequences III

    Toreador (5/1/2012)


    Does anyone have any suggestions for possible uses for sequences? Once upon a time I'd have used them for populating primary keys instead of using identities (ie the way...

  • RE: Sequences III

    I think this question indicates that using default values with a new item like CREATE SEQUENCE isn't a great idea. I, for one, will be defining everything (AS, START...

  • RE: Sequences II

    L' Eomot Inversé (4/25/2012)


    marlon.seton (4/25/2012)


    I'm obviously missing something here.

    "SELECT NEXT VALUE FOR SSC_ROCKS;" is used twice in the question, so why aren't two numbers returned?

    Two numbers are returned. But...

  • RE: Altering a Column

    Toreador (4/25/2012)


    Steve's presumably got rid of the code that automatically told you how many options to choose on a multi-select question 🙁

    What he said.

  • RE: Sequences II

    I'm obviously missing something here.

    "SELECT NEXT VALUE FOR SSC_ROCKS;" is used twice in the question, so why aren't two numbers returned?

Viewing 15 posts - 121 through 135 (of 143 total)