Case statemants in an SQL update query

• shenyjoy

  SSC-Addicted

  Points: 421

  More actions

  May 22, 2008 at 5:13 am

  #186801

  Hi,

  I wanted to know what is the syntax for using case statements in an SQL update query. We are querying an Oracle Table from SQL Server.

  I can use a normal update statement but am unable to do an update with a case statement.

• Dan Murray

  Right there with Babe

  Points: 779

  More actions

  May 27, 2008 at 12:06 pm

  #820736

  Sql Server syntax for updating using a case statement:

  update table_1

  set Datum2=(case when datum1='1' then 'One'

  when datum1='2' then 'two'

  when datum1='3' then 'three'

  else 'four' end)

• gints.plivna

  Ten Centuries

  Points: 1256

  More actions

  May 28, 2008 at 10:38 am

  #821312

  It is always worth to look in Oracle docs CASE Expressions

  Gints Plivna

  http://www.gplivna.eu

  Gints Plivna
  http://www.gplivna.eu

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9149

  More actions

  July 3, 2008 at 2:11 pm

  #838133

  Hi

  Check out the below link

  http://oracle.ittoolbox.com/groups/technical-functional/oracle-dev-l/update-statement-with-case-854527

  Thanks -- Vj

  http://dotnetvj.blogspot.com

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers