Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at Scotch On The Rock (SOTR) 2010 (Munich) with:

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 »