执行Delete From tbAddress Where strName=“萌萌”语句后，共删除（）条记录。A、0B、1C、若干D、全部
执行Delete From tbAddress Where strName=“萌萌”语句后，共删除（）条记录。
- A、0
- B、1
- C、若干
- D、全部
相关考题：
要在tbAddress表中插入记录,下面哪条语句是正确的?() A.Insert Into tbAddress(strName,strTel) Values("萌萌","6545632")B.Insert Into tbAddress(strName,strEmail) Values("萌萌", "")C.Insert Into tbAddress(strName,strEmail) Values("萌萌",NULL)D.Insert Into tbAddress(strName,intAge) Values(萌萌,22)
执行Select Count(*) As Total From tbAddress Group By intAge语句后,会返回多少条记录? () A.0B.1C.2D.与intAge的值有关
从订单表中删除客户号为"1001”的订单记录，正确的SQL语句是A）DROP FROM订单WHERE客户号="1001"B）DROP FROM订单FOR客户号="1001"C）DELETE FROM订单WHERE客户号="1001"D）DELETE FROM订单FOR客户号="1001"
使用SQL语句将表S中字段price的值大于30的记录删除，正确的命令是A．DELETE FROM s FOR price30B．DELETE FROM s WHERE price30C．DELETE s FOR price30D．DELETE s WHERE price30
下列执行数据的删除语句在运行时不会产生错误信息的是( )。 A delete * from A where B=‘6’B delete * from A where B=‘6’C delete A where B=6D delete A set where B=‘6’
下面（）语句可以查询strName为"萌萌"且是2008年8月8日前注册的用户。A、Select * From tbAddress Where strName=萌萌 And dtmSubmit#2008-8-8#B、Select * From tbAddress Where strName="萌萌"And dtmSubmit2008-8-8C、Select * From tbAddress Where strName="萌萌"And dtmSubmit#2008-8-8#D、Select * From tbAddress Where strName="萌萌"Or dtmSubmit#2008-8-8#
要在tbAddress表中插入记录，下面（）语句是正确的。A、Insert Into tbAddress（strName，strTel）Values（"萌萌"，"6545632"）B、Insert Into tbAddress（strName，strEmail）Values（"萌萌"，""）C、Insert Into tbAddress（strName，strEmail）Values（"萌萌"，NULL）D、Insert Into tbAddress（strName，intAge）Values（萌萌，22）
要在tbAddress表中更新记录，下面（）语句是正确的。A、Update tbAddress Set strName="萌萌"，intAge=22 Where ID=2B、Update tbAddress Set strName=萌萌，intAge=22 Where strName=萌萌C、Update tbAddress Set dtmSubmit=2008-10-1 Where strName="萌萌"D、Update tbAddress Set intAge=18
下面（）语句可以查询姓“赵”并且年龄等于22岁的用户。A、Select * From tbAddress Where strName="赵"And intAge=22B、Select * From tbAddress Where strName like"赵%"And intAge="22"C、Select * From tbAddress Where strName like"赵%"And intAge=22D、Select * From tbAddress Where strName like"%赵%"And intAge=22
删除“职工”表中没有写入工资的记录，应该使用的命令是（）。A、DELETE FROM职工WHERE工资=NULLB、DELETE FROM职工WHERE工资=!NULLC、DELETE FROM职工WHERE工资IS NOT NULL
多选题要在tbAddress表中插入记录，下面（）语句是正确的。AInsert Into tbAddress（strName，strTel）Values（萌萌，6545632）BInsert Into tbAddress（strName，strEmail）Values（萌萌，）CInsert Into tbAddress（strName，strEmail）Values（萌萌，NULL）DInsert Into tbAddress（strName，intAge）Values（萌萌，22）
多选题要在tbAddress表中更新记录，下面（）语句是正确的。AUpdate tbAddress Set strName=萌萌，intAge=22 Where ID=2BUpdate tbAddress Set strName=萌萌，intAge=22 Where strName=萌萌CUpdate tbAddress Set dtmSubmit=2008-10-1 Where strName=萌萌DUpdate tbAddress Set intAge=18
单选题下面（）语句可以查询姓“赵”并且年龄等于22岁的用户。ASelect * From tbAddress Where strName=赵And intAge=22BSelect * From tbAddress Where strName like赵%And intAge=22CSelect * From tbAddress Where strName like赵%And intAge=22DSelect * From tbAddress Where strName like%赵%And intAge=22
单选题下面（）语句可以查询strName为"萌萌"且是2008年8月8日前注册的用户。ASelect * From tbAddress Where strName=萌萌 And dtmSubmit#2008-8-8#BSelect * From tbAddress Where strName=萌萌And dtmSubmit2008-8-8CSelect * From tbAddress Where strName=萌萌And dtmSubmit#2008-8-8#DSelect * From tbAddress Where strName=萌萌Or dtmSubmit#2008-8-8#