A. UPDATE S
SET grade=85
WHERE SN=’王二’ AND CN=’化学’
B. UPDATE S
SET grade=’85’
WHERE SN=’王二’ AND CN=’化学’
C. UPDATE grade=85
WHERE SN=’王二’ AND CN=’化学’
D. UPDATE grade=’85’
WHERE SN=’王二’ AND CN=’化学’
A.UPDATE Student SET sdept ='计算机系’ WHHERE Sname='张三' AND sdept='信息系’
B.UPDATE Student SET sdept = '计算机系' WHERE Sname='张三'
C.UPDATE Student SET sdept = '信息系' WHERE Sname='张三' AND sdept='计算机系'
D.UPDATE Student SE T sdept ='信息系' WHERE Sname='张三'
A.UPDATE职工SET工资=工资+10性别="女"
B.UPDATE职工SET工资=工资+10And性别="女"
C.UPDATE职工SET工资=10WHERE性别="女"
D.UPDATE职工SET工资=工资+10WHERE性别="女"
A.Update商品表单价=单价0.9
B.Update商品表Set单价With单价0.9
C.Update商品表Set单价=单价0.9
D.Update商品表where单价=单价0.9
所有学员的成绩加10分。下列SQL语句正确的是()。
A、update students set Grade=Grade+10 where SID=1
B、update * set Grade=Grade+10
C、update * from stedents set Grade=Grade+10
D、update students set Grade=Grade+10