create table EmployeeTest(id int,Name varchar(50),Address varchar(50),Salary float)
insert into EmployeeTest values(101,'yjreddy','hyderabad',42000)
insert into EmployeeTest values(102,'Dmreddy','Vizag',32000)
update EmployeeTest set Salary=
case
when Salary=42000 then Salary+10000
end