Loading

i WANT TO UPDATE JOB COLUMN WITH DIFFERENT POSITIONS

Krunal Parate

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Azeem Anzari11y ago
you can go with stored procedure and pass the Eno as parameter,job 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
0