Archive for August, 2006
Finally I have my own domain name. Please click HERE to read this same post on my new site. Thanks!
i remember there is one time where i have to edit an old module where in the date field in sql is not a date data type but instead, it is a char type… they did [...]
Filed under: SQL | 7 Comments
Tags: month, SQL date, year
Prayers Do Come True
There are three essential parts in prayer. one is you pray, second is you believe, third is you act. All of these are needed for your prayer to be answered.
You pray, its too obvious this one is needed in prayer. duh?!? but of course you have to know what’s for you and what’s not [...]
Filed under: Personal, Thoughts | 4 Comments
Tags: Prayer, Thoughts
Old Days
I remember last week when i got a free time and ended up reading my friendster profile specifically my friend’s testimonials to me, it was a really great way to spend a dead afternoon. A great time really! I really felt good reading it. I started to realize how I became part of their lives, [...]
Filed under: Personal | 1 Comment
Comment
I just recently started my technical blog in wordpress.com. I’m just a newbie in my job so you could count my blog post in your fingers. I post evry problems that i encountered in my career as a software developer. I also explained evry details how i manage to solve it. After a few postings, [...]
Filed under: Personal | Leave a Comment
Finally I have my own domain name. Please click HERE to read this same post on my new site. Thanks!
I had a query once that contains a divide operation….
SELECT x, y, ROUND(x/y) as quotient
FROM dataTbl
It always returns a correct value…
but divide by zero error occurs whenever
there is a zero(0) not NULL value in y column…
now, what i [...]
Filed under: SQL | 5 Comments
Tags: divide by zero, divide error, SQL isZero