您的数据库中包含一个名为Customer的表。您需要从Customer表中删除Customer表中删除CustomerID为12345的记录。您应该使用哪个语句？
A: DELETE FROM Customer WHERE CustomerID = 12345
B: DELETE CustomerID FROM Customer WHERE CustomerID = 12345
C: UPDATE Customer DELETE * WHERE CustomerID = 12345
D: UPDATE CustomerID FROM DELETE * CustomerID = 12345
A: DELETE FROM Customer WHERE CustomerID = 12345
B: DELETE CustomerID FROM Customer WHERE CustomerID = 12345
C: UPDATE Customer DELETE * WHERE CustomerID = 12345
D: UPDATE CustomerID FROM DELETE * CustomerID = 12345
举一反三
- dt为DataTable类型的变量，引用名为"Customers"的DataTable对象。该表中包含"CustomerID"、"CustomerName"、"Address"、"Telephone"等4列。将数据列"CustomerID"设为该表的主键的正确语句有：（） A: dt.PrimaryKey="CustomerID"； B: dt.PrimaryKey.Add（"CustomerID"）； C: dt.PrimaryKey=newobject[]{"CustomerID"}； D: dt.PrimaryKey=newDataColumn[]{dt.Columns["CustomerID"]}；
- 您有一个名为Customer的表,此表具有名为CustomerID,FirstName和DateJoined的列。CustomerID是主键。您执行以下语句:SELECTCustomerID,FirstName,DateJoinedFROMCustmoer结果集中的行如何排列的? A: 没有可预测的顺序 B: 按FirstName的字母顺序 C: 按DateJoined的时间顺序 D: 按插入行的顺序
- 删除表course的记录。其SQL语句为（ ）。 A: DELETE from course where * B: DELETE * from course C: DELETE course D: DELETE FROM course
- 智慧职教: 客户表(customer) （ 客户主键ID： customerid int, 客户姓名： fullname varchar(20), 客户年龄 age int ） 订单表(order) ( 订单主键ID： orderid int, 订单总金额 allamount numeric(10, 2) 订单日期 orderdate datetime, 所属客户ID: customerid int, ) 查询所有客户的订单信息， 没有订单的客户也显示出来
- 删除demo表中id为1001的记录。其SQL语句为（ ）。 A: delete from demo where id=1001 B: delete demo C: delete from dmeo where id=1001 D: delete demo where id=1001