有两个变量cno,cname已赋值,对应关系COURSE中字段cno,cname。 则将表中指定cno值的数据对应的cname属性值改变为新指定的正确的嵌入 式SQL语句格式是( )。
A.
EXEC SQL UPDATE COURSE SET (cname=:cname) WHERE cno=:cno;
B.
EXEC SQL UPDATE COURSE SET (cname=cname) WHERE cno=cno;
C.
EXEC SQL UPDATE COURSE SET (:cname=cname) WHERE :cno=cno;
D.
EXEC SQL UPDATE COURSE SET (:cname=:cname) WHERE :cno=:cno;