update tblnm set city = case when city = 'ahmedabad' then 'pune' else 'ahmedabad' end where city in ('ahmedabad','pune')
1) update Mytable set city='Ahmedabad' where id in (2,4) 2) update Mytable set city='Pune' where id in (3,1)'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)