SQL语句“delete from department”，需要SqlCommand对象的哪一个方法在执行（）。A、ExecuteNonQuery（）B、ExecuteScalar（）C、ExecuteReader（）D、ExecuteXmlReader（）
SQL语句“delete from department”，需要SqlCommand对象的哪一个方法在执行（）。
- A、ExecuteNonQuery（）
- B、ExecuteScalar（）
- C、ExecuteReader（）
- D、ExecuteXmlReader（）
相关考题：
使用SQL语句将学生表S中年龄（AGE）大于30岁的记录删除，正确的命令是（ ）。A．DELETE FOR AGE30B．DELETE FROM S WHERE AGE30C．DELETE S FOR AGE30D．DELETE S WHERE AGE30
从订单表中删除客户号为"1001”的订单记录，正确的SQL语句是A）DROP FROM订单WHERE客户号="1001"B）DROP FROM订单FOR客户号="1001"C）DELETE FROM订单WHERE客户号="1001"D）DELETE FROM订单FOR客户号="1001"
使用SQL语句将学生表S中年龄(AGE）大于30岁的记录删除，正确的命令是A）DELETE FOR AGE30 B）DELETE FROM S WHERE AGE30C）DELETE S FOR AGE30 D）DELETE S WHERE AGE30
在VisualFoxPro中，如果要将学生表S(学号，姓名，性别，年龄)的“年龄”属性删除，正确的SQL语句是（ ）。A) ALTER TABLE S DROP COLUMN年龄B)DELETE年龄FROM SC)ALTER TABLE S DELETE COLUMN年龄D)ALTER TABLE S DELETE年龄
下面SQL语句不正确的是() A.Select*from userB.update user set username=’zhangsan’where id=’2’C.Delete*from userD.insert into user values(1,’zhang’,’pass’);
根据SQL标准，要删除表student中所有数据，但不将表student的定义一起删除，下面哪个语句可以适用?()A delete from studentB delete all from studentC delete * from studentD drop table student
Examine the data in the EMPLOYEES and DEPARTMENTS tables:Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:What happens when you execute the DELETE statement?（）A. Only the row with department ID 40 is deleted in the DEPARTMENTS table.B. The statement fails because there are child records in the EMPLOYEES table with department ID 40.C. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.D. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.E. The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.F. The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.
从订单表中删除客户号为“1001”的订单记录，正确的SQL语句是A．DROP FROM 订单 WHERE客户号=“1001”B．DROP FROM 订单 FOR 客户号= “1001”C．DELETE FROM 订单 WHERE 客户号=“1001”D．DELETE FROM 订单 FOR 客户号=“1001”
下列描述中，错误的是______。A．SQL中的DELETE语句可以删除一条记录B．SQL中的DELETE语句可以删除多条记录C．SQL中的DELETE语句可以用子查询选择要删除的行D．SQL中的DELETE语句可以删除子查询的结果
使用SQL语句将表s中字段price的值大于30的记录删除，正确的命令是（ ）。A.DELETE FROM S FOR price30B.DELETE FROM sWHERE price30C.DELETE S FOR pricC30D.DELETE S WHERE pricC30
删除“持有数”表中所有外币名称为“法郎”的记录，下列SQL语句正确的是( )。A．DELETE FROM 持有数; WHERE 持有数.外币代码=外汇名.外币代码; AND 外币名称="法郎"B．DELETE FROM 持有数,外汇名; WHERE 持有数.外币代码=外汇名.外币代码; AND 外币名称="法郎"C．DELETE FROM 持有数 WHERE 外币代码 IN; (SELECT 外币代码 FROM 外汇名 WHERE 外币名称="法郎")D．DELETE FROM 持有数 WHERE 外币代码 IN; SELECT 外币代码 FROM 外汇名 WHERE 外币名称="法郎"
使用SQL语句将表S中字段price的值大于30的记录删除，正确的命令是A．DELETE FROM s FOR price30B．DELETE FROM s WHERE price30C．DELETE s FOR price30D．DELETE s WHERE price30
从“订单”表中删除签订日期为2004年1月10日之前(含)的订单记录，正确的SQL语句是（ ）。A)DROP FROM 订单 WHERE 签订日期={A2004．1．10}B)DROP FROM 订单 FOR 签订日期={2004．1一l0}C)DELETE FROM 订单 WHERE 签订日期={2004—1．10}D)DELETE FROM 订单 FOR 签订日期_{2004．1一l0}
BookStore数据库中有出版社表从Publisher表删除“群众出版社”。SQL语句：（）A、DELET Epublisher WHERE Publisher=‘群众出版社’B、DELETE FROM Publisher WHERE Publisher=‘群众出版社’C、DELETE FROM Publisher WHERE Publisher=群众出版社D、DELETE Publisher WHERE Publisher=群众出版社
下列哪个SQL语句可以用于从表users中删除数据：（）。A、REMOVE TABLE usersB、DROP TABLE usersC、DELETE FROM usersD、ALTER TABLE users
下列SQL Server语句中出现语法错误的是（）。A、DECLARE @Myvar INTB、SELECT * FROM [AAA]C、CREATE DATABASE AAAD、DELETE * FROM AAA
在Access中，删除"订单"表中所有记录，应运行的SQL命令是（）A、delete*from"订单"B、delete*from订单C、delete*from"订单ID"D、delete*from订单ID
删除emp表的全部数据，但不提交，以下正确的语句是（）A、DELETE * FROM. EMPB、DELETE FROM EMPC、TRUNCATE TABLE EMPD、DELETE TABLE EMP"
下列Transact-SQL语句中出现语法错误的是（）。A、declare @ab cintB、select*from 学生C、delete*from 学生D、update 学生 set 考核=‘优’
下面哪一个SQL语句将删除DEPT表中的所有数据，并永久删除DEPT表的整个结构（）A、DROP TABLE dept;B、DELETE TABLE dept;C、TRUNCATE TABLE dept;D、DELETE * . * FROM dept; [END CODE]"
单选题SQL语句“delete from department”，需要SqlCommand对象的哪一个方法在执行（）。AExecuteNonQuery（）BExecuteScalar（）CExecuteReader（）DExecuteXmlReader（）