Forum Replies Created

Viewing 15 posts - 16 through 30 (of 147 total)

  • RE: Remove data from tables

    ... but TRUNCATE statement do not logging.

    Oh boy, here we go again...

    ---------------
    Mel. 😎

  • RE: Remove data from tables

    Koen Verbeeck (3/5/2015)


    Hany Helmy (3/5/2015)


    Jostein Saethern (3/4/2015)


    The "delete table BBB;" statement in d) will fail.

    Its just a typo.

    That's not a typo, that is a mistake.

    DELETE FRAM BBB, that is a...

    ---------------
    Mel. 😎

  • RE: Remove data from tables

    Koen Verbeeck (3/5/2015)


    Nice question, unfortunately poorly implemented.

    +1

    ---------------
    Mel. 😎

  • RE: Maximum number of databases per instance

    Thanks for the question.

    ---------------
    Mel. 😎

  • RE: Approximate Data types

    Good question. Thanks!

    ---------------
    Mel. 😎

  • RE: SSIS-Transactions

    Good question.

    Thank you.

    ---------------
    Mel. 😎

  • RE: Empty TABLE

    Interesting question. Made me think a little since I obviously never tried it before.

    Guessed it right because I was sure there had to be some sort of validation to prevent...

    ---------------
    Mel. 😎

  • RE: The PIVOT

    Good question.

    Thanks!

    ---------------
    Mel. 😎

  • RE: Getting Distinct

    Yes, this was easy for me but only because I ran a query like that a looooong time ago and remembered. 🙂

    Thanks for the question.

    ---------------
    Mel. 😎

  • RE: Distinct Counts

    Good question. Thanks

    ---------------
    Mel. 😎

  • RE: Error messages

    I think the crux of the question is what would happen if ERROR_MESSAGE() is used outside the context of a TRY... CATCH... block (i.e. nothing)

    Exactly.

    ---------------
    Mel. 😎

  • RE: Error messages

    Very good question, IMO.

    Thanks

    ---------------
    Mel. 😎

  • RE: Fun with XOR #1

    Thanks for the question.

    ---------------
    Mel. 😎

  • RE: Memory

    I'm not even going to say anything....

    ---------------
    Mel. 😎

  • RE: TSQL "where - 101"

    Mark Grout (11/12/2014)


    The question said "every employee", that should be clear enough, one record per employee. If you DISTINCT, you get list of peoples names, not people.

    "There's Brian over there,...

    ---------------
    Mel. 😎

Viewing 15 posts - 16 through 30 (of 147 total)