Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Sumit Verma and Jarrod Stiles and Marc Esher
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Sumit Verma , Jarrod Stiles , and Marc Esher

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 »