i WANT TO UPDATE JOB COLUMN WITH DIFFERENT POSITIONS

Question

Eno	Ename	Job	Salary	Image
100	AA	NULL	1200	NULL
101	BB	NULL	1320	NULL
102	CC	NULL	1800	NULL
103	DD	NULL	1500	NULL

 

THIS IS MY TABLE..IF I WANT TO UPDATE MY JOB COLUMN WITH DIFFERENT POSITIONS LIKE  TEACHER, CLERK,MANAGER AND SO ON..SO HOW CAN I WRITE THE QUERY.. DO I NEED TO WRITE SEPARATE QUERY FOR EACH RECORD LIKE UPDATE EMP SET JOB =CLERK WHERE ID=101 OR CAN I WRITE THE SINGLE SQL STATEMENT TO UPDATE ALL RECORD IN SQL SERVER