Which University did you graduate from?

My sql script encountered some error last night. Once again, my question was, why didn’t the testing team encounter this error during testing phrase? Oh well, have to except the fact that testing cannot cover all the scenarios in the system. Can’t really blame them.

Another colleague from another team who was working on the same issue came to me first thing I reach office today and told me that my script hit error. For those who know SQL, I was doing some update statement and it hit trigger. That why it hit error.

Then this guy asked me “So did the changes go thru?”

I paused for a few seconds and looked at him, wondering how to answer that question. Finally, my answer to him was “No lah, hit error how to go thru?”

But deep down inside, I wanted to ask “Which University did you graduate from?”

On second thoughts, maybe I should say “Of cos went thru. Hit trigger only what. Hit trigger the update statement still go thru one. No worries.”

PS: Sorry for being rude. But sometimes I just get pissed off when people asked me questions that are damn obvious. If the SQL update statement hit error (trigger), how could the changes have gone thru? I guess even non-IT trained people would have guess that too.

Who needs Dibert when I have colleagues like this?

6 comments

  1. When a stored procedure contains multiple SQL statements, it is possible that statements before the error line go thru unless all statements are encapsulated in a sql transaction.

  2. HOHOHO now i know who to go to when I have MYSQL problems. You have no idea how many times I accidentally deleted the entire database…

  3. Anon1: But the problem is, this is just a normal single line update statement.

    Precious: What software are you using? Some software actually warns you before you do update/delete without a where clause.

    Anon2: I haven’t grad yet. 😀

  4. Ah, there was once my lecturer was using one MS SQL database to demonstrate how we could access databases using programming APIs.

    I wrote a script with a timer that caused the following to run every 30 seconds.

    DROP TABLE demo

    Morale of the story: don’t ever use the same database as your students when you are doing a live demo in class!

Leave a Reply

Your email address will not be published. Required fields are marked *