要在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
下面哪条语句可以查询姓“赵”并且年龄等于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
执行Delete From tbAddress语句后,共删除多少条记录?( ) A: 0 B: 1 C: 15 D: 全部
执行Delete From tbAddress语句后,共删除多少条记录?( ) A: 0 B: 1 C: 15 D: 全部
1