Kenny

Recent Blog Comments By Kenny

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 »

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 am the co-founder and lead engineer at InVision App, Inc — the world's leading prototyping,
collaboration & workflow platform. I also rock out in JavaScript and ColdFusion 24x7 and I dream about
promise resolving asynchronously.