Case statemants in an SQL update query

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Dan Murray Right there with Babe Points: 779 More actions · Answer 1

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 · Answer 2

It is always worth to look in Oracle docs CASE Expressions

Gints Plivna

Vijaya Kadiyala SSCrazy Eights Points: 9149 More actions · Answer 3

Hi

Check out the below link

Thanks -- Vj

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

Cookies on SQLServerCentral