在SQL Server 2000中删除表STUDENT中姓名为张岚的数据行，SQL语句应为______
A: DELETE STUDENT WHERE XM=张岚
B: DROP STUDENT WHERE XM="张岚"
C: DELETE STUDENT WHERE XM="张岚"
D: 以上都不正确
A: DELETE STUDENT WHERE XM=张岚
B: DROP STUDENT WHERE XM="张岚"
C: DELETE STUDENT WHERE XM="张岚"
D: 以上都不正确
举一反三
- 在SQL Server-2000中删除表STUDENT 中姓名为张岚的数据行，SQL语句应为______ A: DELETE STUDENT WHERE XM=张岚 B: DROP STUDENT WHERE XM="张岚" C: DELETE STUDENT WHERE XM="张岚" D: 以上都不正确
- 下列关于删除表中记录的SQL语句,正确的是( )。 A: DELETE student,where id=11; B: DELETE FROM student where id=11; C: DELETE INTO student where id=11; D: DELETE student where id=11;
- 从学生表中删除学号为“1001”的学生记录，正确的SQL语句是______。 A: DROP FROM Student WHERE 学号="1001" B: DROP FROM Student FOR 学号="1001" C: DELETE FROM Student WHERE 学号="1001" D: DELETE FROM Student FOR 学号="1001"
- 删除student表中学号为101的记录。其SQL语句为（ ）。 A: DELETE stu where stu_no=101 B: DELETE studnets C: DELETE student WHERE stu_no=101 D: DELETE FROM student WHERE stu_no=101
- 删除student表中id为1的记录，下列语句正确的是 A: DELETE student WHERE id=1; B: DELETE FROM student WHERE id=1; C: DELETE FROM student WHERE id:=1; D: DELETE student WHERE id:=1;