blog.dk.sg now!!!" />

« Home | Did they check properly before hiring? » | NSF arrested along orchard with SAR21 and bullets » | Saw IV Trailer » | Funny letters to ST Forums » | Zeroes - ordinary people with pointless abilities » | Shirlyn Tan - Couldn't We Try » | Appreciation » | Diana, Princess of Wales (1 July 1961 - 31 August ... » | Tears » | Workers' Party should not be allowed to hold cycli... »

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?

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.

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...

More importantly DK, which university did YOU go to? ;)

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. :D

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!

pkchukiss: Morale of the story should be "Never grant student admin rights" :P

Post a Comment
My Photo

About me

Twitter

    Connecting to Twitter....


    Connecting to Twitter....


    Connecting to Twitter....


http://twitter.com/dk

MyBlogLog

Powered by Blogger


Blogger Templates

eXTReMe Tracker