Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
i WANT TO UPDATE JOB COLUMN WITH DIFFERENT POSITIONS
Krunal Parate
Sep 7 2015 3:59 PM
338
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
bindgrid
ddl