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.

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