Sql update command question

Kasarus

Hi,

I want to know are there any ways to do the statement below in one SQL command?

update [table_a] set [column_a] = 'A' where id in (1,2,3)
update [table_a] set [column_a] = 'B' where id in (4,5,6)

(above statement use 2 times for updating)

PS. thanks for advise if it possible to do :D

ck9663

Yes, use the CASE statement.

Expand|Select|Wrap|Line Numbers

  
update [table_a] 

set [column_a] = 

case when id in (1,2,3) then 'A' when id in (4,5,6) then 'B' else NULL end

Happy Coding!!!

--- CK

Kasarus

It's works ! thank you very much

however It's modified all records in the table, if i'd like to modify only in the set of ids, is it possible?

Kasarus

I got the solution now, it's just add the 'where' clause after end case :D

Sql update command question

re: Sql update command question

re: Sql update command question

re: Sql update command question

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about