| 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