Forum Replies Created

Viewing 15 posts - 226 through 240 (of 703 total)

  • RE: T-SQL Logic

    OCTom (6/22/2010)


    And the point is?... lost on me... again.:w00t:

    Yes, it was relatively simple to analyze, but some of the QOD's should be at an elementary level. Not all members of...

  • RE: Careful with table name alias

    This was a good way to point out the risk of using reserved words within brackets as a user-defined object. While I would suppose few people would want...

  • RE: Date data type

    webrunner (4/28/2010)


    ........ Most other answers include a reference link, and I didn't see one for this question.........................

    To save anyone the trouble of finding where the heck this is, it's documented...

  • RE: what does the second @@error return?

    Mohamed-401375 (4/26/2010)


    Nice question.

    Tricky though. Makes you read closely.

    I agree. My first reaction was that the two "raiseerror' invocations were identical. But then I did look more closely...

  • RE: Defensive Programming

    Hugo Kornelis (4/23/2010)


    I got it right, but I don't like the question.

    The QotD should be about testing our knowledge of SQL Server. Not testing our ability to use a search...

  • RE: Uncommitted implicit transactions

    My understanding is that DBCC OpenTran looks at the transaction log for the oldest transaction not yet committed. If there's no change to the db, then nothing is written...

  • RE: NULL

    steve block (4/15/2010)


    I think it would have been delicious to have one of the options for the answer to be "I Don't Know" and it be the correct response.

    Steve

    Excellent! ...

  • RE: NULL

    Thank you, Pradyothana. Although by now you may be reeling from the "bad question" comments, I'd like to thank you for submitting this one. So many have...

  • RE: TSQL

    malleswarareddy_m (4/6/2010)


    john.arnott (4/6/2010)


    malleswarareddy_m (4/5/2010)


    john.arnott (4/5/2010)


    malleswarareddy_m (4/4/2010)


    Good QOD.This Question gives good information about bit datatypes.

    when we use space or all zero it bit will convert it into zero.If we give numeric(numbers)...

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/6/2010)


    My next response will be to use 5.25 floppies. Maybe sneakernet will work.

    Or 8" floppies for that good old nineteen seventies vibe.

  • RE: No More NULL

    Rod at work (4/5/2010)


    A friend of mine thinks that if you cross the International Date Line, say going from west to east, that you can actually travel back in time....

  • RE: TSQL

    malleswarareddy_m (4/5/2010)


    john.arnott (4/5/2010)


    malleswarareddy_m (4/4/2010)


    Good QOD.This Question gives good information about bit datatypes.

    when we use space or all zero it bit will convert it into zero.If we give numeric(numbers) it will...

  • RE: Are the posted questions getting worse?

    Alvin Ramard (4/5/2010)


    OS/2 = 1/2 * OS = half an operationg system 😀

    LOL.... Good answer to the OS/2 fanatics that would refer to "win-doze" or "isNT an OS"....

  • RE: TSQL

    malleswarareddy_m (4/4/2010)


    Good QOD.This Question gives good information about bit datatypes.

    when we use space or all zero it bit will convert it into zero.If we give numeric(numbers) it will convert it...

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (3/31/2010)


    (whew) It took me 45 minutes to catch up.... I'm out of breath from reading so fast.

    1. How hard can it be to spell...

Viewing 15 posts - 226 through 240 (of 703 total)