Community Member Profile
Ananthanarayanan
Member since Nov 16, 2011
- Profile: /members/9252-Ananthanarayanan.htm
- Comments: 1
- Points: 9
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
read more »
