Monday, July 29, 2013

CASE Statements in A SQL UPDATE Query

  • UPDATE
  • [account]
  • SET
  • balance =
  • (
  • CASE
  • WHEN
  • ((balance - 10.00) < 0)
  • THEN
  • 0
  • ELSE
  • (balance - 10.00)
  • END
  • )
  • WHERE condition
Written by Date
Topic

No comments:

Post a Comment

Please leave your comments

Subscribe to: Post Comments (Atom)