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 CLERKMANAGER 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

Azeem Anzari · Answer

you can go with stored procedure and pass the Eno as parameterjob as parameters and execute it. this is the best way Create Procedure updateEmployeeejobs @Eno int@job varchar(10) As Begin update employee set job=@job where eno=@Eno End -- for executing the stored procedure in the sql server execute updateEmployeejobs 1'Manager' or else you can also execute it through c# code Regards Azeem

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