Hi,

Hope this may help you..

update AppInvent_Test set Designation='PAT' where EmpID in (1,2)

Regards,

Revathy