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?
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.
Posted by Anonymous | 9/05/2007 05:35:00 PM
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...
Posted by Anonymous | 9/05/2007 08:04:00 PM
More importantly DK, which university did YOU go to? ;)
Posted by Anonymous | 9/05/2007 08:46:00 PM
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
Posted by DK | 9/06/2007 12:17:00 AM
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!
Posted by Pkchukiss | 9/09/2007 02:53:00 PM
pkchukiss: Morale of the story should be "Never grant student admin rights" :P
Posted by DK | 9/10/2007 12:25:00 AM