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)
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
A.Select * From tbAddress Where strName=萌萌 And dtmSubmit<#2008-8-8# B.Select * From tbAddress Where strName="萌萌"And dtmSubmit<2008-8-8 C.Select * From tbAddress Where strName="萌萌"And dtmSubmit<#2008-8-8# D.Select * From tbAddress Where strName="萌萌"Or dtmSubmit<#2008-8-8#