• 2022-05-31 问题

    要在tbAddress表中更新记录,下面哪条语句是正确的?( ) A: Update tbAddress Set strName="萌萌",intAge=22 Where ID=2 B: Update tbAddress Set strName=萌萌,intAge=22 Where strName=萌萌 C: Update tbAddress Set dtmSubmit=2008-10-1 Where strName="萌萌" D: Update tbAddress Set intAge=18

    要在tbAddress表中更新记录,下面哪条语句是正确的?( ) A: Update tbAddress Set strName="萌萌",intAge=22 Where ID=2 B: Update tbAddress Set strName=萌萌,intAge=22 Where strName=萌萌 C: Update tbAddress Set dtmSubmit=2008-10-1 Where strName="萌萌" D: Update tbAddress Set intAge=18

  • 2022-06-15 问题

    下面哪条语句可以查询姓“赵”并且年龄等于22岁的用户,请问用哪条语句?( ) A: Select * From tbAddress Where strName="赵" And intAge=22 B: Select * From tbAddress Where strName like "赵%" And intAge="22" C: Select * From tbAddress Where strName like "赵%" And intAge=22 D: Select * From tbAddress Where strName like "%赵%" And intAge=22

    下面哪条语句可以查询姓“赵”并且年龄等于22岁的用户,请问用哪条语句?( ) A: Select * From tbAddress Where strName="赵" And intAge=22 B: Select * From tbAddress Where strName like "赵%" And intAge="22" C: Select * From tbAddress Where strName like "赵%" And intAge=22 D: Select * From tbAddress Where strName like "%赵%" And intAge=22

  • 2022-06-06 问题

    执行Delete From user Where strName=“zhangsan”语句后,共删除多少条记录? A: 全部 B: 若干条 C: 1 D: 0

    执行Delete From user Where strName=“zhangsan”语句后,共删除多少条记录? A: 全部 B: 若干条 C: 1 D: 0

  • 1