Kasarus
Last Activity: Oct 21 '09, 08:04 AM
Joined: Oct 19 '09
Location:
-
I got the solution now, it's just add the 'where' clause after end case :D -
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?Leave a comment:
-
Sql update command question
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
No activity results to display
Leave a comment: