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