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

Comments

Post a Comment

Please leave your comments

Popular posts from this blog

Introduction to Computer Security

What is computer security? Security is risk management. - unknown "A computer is secure if you can depend on it and it's software to behave as you expect" - Practical UNIX and Internet Security Security is: availability, consistency, access control, data confidentiality, authentication. -  http://www.sun.com/security/overview.html "The principal objective of computer security is to protect and assure the confidentiality, integrity, and availability of automated information systems and the data they contain." -  http://csrc.nist.gov/publications/secpubs/cslaw.txt There are numerous definitions for "computer security", and most of them are correct. Essentially computer security means enforcement of usage policies, this must be done since people and software have flaws that can result in accidents, but also because someone may want to steal your information, use your resources inappropriately or simply deny you the use of your resources. S...
Read more

How to Fix ( Failed To Create A Phonebook Entry)

Failed To Create A Phonebook Entry |Fix This Error If you are logged on to your PC or laptop using a Guest account. Try to logon using an account with Administrative rights and then try if you are getting the same error ”Failed to create a phonebook entry". If the answer is yes, then try the following… For Windows XP Operating System: First ensure show hidden Files & Folders is checked under folder options. From  My Computer  select  Tools  followed by  Folder Options  then  View.  Under  Advanced settings  tick  Show Hidden Files and Folders  then select  Apply , then  OK. Browse to  C:\Documents and Settings\All Users\Application Data\Microsoft\Network\Connections\Pbk Right click on  Rasphone  file and click  Properties . If the  Read Only  box is checked, remove this, then select  Apply  then  OK . Rename the folder called  pbk  to...
Read more