Skip to main content

Kenny

Member since Dec 11, 2008

Recent Blog Comments By Kenny

  • Using CASE Statements In A SQL UPDATE Query

    Posted on Nov 3, 2008 at 11:21 AM

    Yes, that's what I am trying to do. I have many stored procedures update the same table but different fields, and I am thinking to merge them into one sproc. By doing so, the front end developer can just call the same sproc and do several update processes by varying the keywords.... read more »

  • Using CASE Statements In A SQL UPDATE Query

    Posted on Oct 23, 2008 at 11:54 AM

    Hi, What if I want to "switch" the field name? Your example is Update xxx Set balance = (Case ..... End) Where ...... But I want to do like this: Update xxx Set (Case ..... End) = 1000 Where ...... I have tried this syntax, but it doesn't... read more »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
— Ben Nadel