Forum Replies Created

Viewing 15 posts - 1 through 15 (of 30 total)

  • RE: Nested triggers 1

    Hugo Kornelis (4/23/2013)

    The same applies to QotD authors. "Kill your darlings".(My own QotD's probably suffer from the same problem -though I don't think I've ever had *this* amount of...

    April 23, 2013 at 8:09 am

    #1609078

  • RE: COUNT() Function

    Hugo Kornelis (4/16/2013)

    And for the sake of completeness - the use of COUNT(1) instead of COUNT(*) to count the number of rows is very common. Long ago (I think it...

    April 16, 2013 at 12:12 pm

    #1606970

  • RE: TRIGGERS

    sestell1 (4/9/2013)

    Arrrr, ya got me. I fell for the logic error and completely missed the TEXT data type.

    :blink::blink:

    I recently corrected an error in a trigger code thats using COUNT(*)...

    April 9, 2013 at 9:11 am

    #1604888

  • RE: TRY...CATCH

    Revenant (4/2/2013)

    I like to terminate each statement with a semicolon and I made this mistake years ago: "Experience is an euphemism for our past mistakes."

    +1

    I had the same tendency and...

    April 2, 2013 at 2:15 pm

    #1602953

  • RE: TRY...CATCH

    Hugo Kornelis (4/2/2013)

    Good question, but the explanation falls a bit short. I was very disappointed when I first saw this behaviour. A semicolon is a statement terminator and should be...

    April 2, 2013 at 7:49 am

    #1602800

  • RE: LEN()

    Thanks for the easy question to end the day... haha.. I got burnt with the LEN overlooking the leading spaces once...Good that I remember a lesson learnt in the past.....

    March 29, 2013 at 7:42 am

    #1602017

  • RE: Truncate Table

    AAhhhh!!!!!! This one hurts.. I didn't trust my instincts and on top was lazy to check...

    March 28, 2013 at 7:07 am

    #1601602

  • RE: Delete v Truncate

    sknox (3/21/2013)

    Mechanically, TRUNCATE TABLE is DDL: It doesn't act on the row data, but on the metadata (this is why you need ddladmin rights.)

    But functionally it's DML: its function...

    March 21, 2013 at 12:54 pm

    #1599543

  • RE: Full-Text Search – Thesaurus Languages

    sestell1 (3/19/2013)

    Interesting question. In researching this, I was amazed how many posts I found stating that SQL Server needed to be restarted after changing a thesaurus file.

    aahh!!! As soon...

    March 20, 2013 at 2:51 pm

    #1599144

  • RE: Precision required

    L' Eomot Inversé (3/14/2013)

    Nice question and correct answer (pity about the locale issue, though).

    Unfortunately, the explanation is rather wrong - not surprising, as the BOL page on smalldatetime also gets...

    March 14, 2013 at 7:41 am

    #1597000

  • RE: INNER JOIN

    As soon as I saw the options,

    My BRAIN: Its easy! There could be some rows returned based on the sysdatetime() entry like in case of '2013-03-12 11:25:21.290000' which...

    March 12, 2013 at 10:02 am

    #1596107

  • RE: OUTPUT - 1

    I learnt something new today.. I got the answer right but after reading about output and taking for granted the default case insensitive collation. But when I realized that output...

    February 27, 2013 at 8:27 am

    #1591581

  • RE: Locking Hints

    hey hey I got it right but have to admitt I overlooked the mispelled with and went ahead.. thanks for the qotd

    February 21, 2013 at 11:28 am

    #1590082

  • RE: THROW - 1

    wolfkillj (2/20/2013)

    L' Eomot Inversé (2/20/2013)

    Nice interesting question.

    I really must upgrade and get SQL2012 so that I can start playing with this stuff instead of just reading about it.

    If people have...

    February 20, 2013 at 12:49 pm

    #1589695

  • RE: Update with CASE statement

    A 'confusingly' straightforward question 😉

    February 19, 2013 at 9:19 am

    #1589262

Viewing 15 posts - 1 through 15 (of 30 total)