Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2008 (Washington, D.C.) with: Qasim Rasheed and Sana Ullah
Ben Nadel at CFUNITED 2008 (Washington, D.C.) with: Qasim Rasheed ( @qasimrasheed ) and Sana Ullah

Ananthanarayanan

Member since Nov 16, 2011

Recent Blog Comments By Ananthanarayanan

  • Using CASE Statements In A SQL UPDATE Query

    Posted on Nov 16, 2011 at 9:27 AM

    @Ben- Thanks for posting this.. @Pinal, I am wondering whether it has any performance issues or whether IF is a better choice here. This is what i did.... UPDATE MyTable SET MyColumn=CASE WHEN @MyVariable IS NOT NULL THEN @MyVariable ELSE MyColumn END WHERE <some condition> Will be good ... read more »