将员工号为1007的员工薪水改为3500,职位改为Programmer,下列SQL语句正确的是：（）
A.updateemp setsalary=3500andjob='Programmer' whereempno=1007;
B.updateemp setsalary=3500,setjob='Programmer' whereempno=1007;
C.updateemp salary=3500,job='Programmer' whereempno=1007;
D.updateemp setsalary=3500,job='Programmer' whereempno=1007;
正确答案是D