在SQLServer2000中,查询表STUDENTl中所有李姓的学生。在查询分析器中应执行()
A.SELECT*FROMSTUDENTlWHEREXMLIKE‘李’ B.SELECT*FROMSTUDENTlWHEREXMLIKE1李%’ C.SELECT*FROMSTUDENTlWHEREXMIS‘李%’ D.以上都不是正确答案B
在SQLServer2000中,查询表STUDENTl中所有李姓的学生。在查询分析器中应执行()
A.SELECT*FROMSTUDENTlWHEREXMLIKE‘李’ B.SELECT*FROMSTUDENTlWHEREXMLIKE1李%’ C.SELECT*FROMSTUDENTlWHEREXMIS‘李%’ D.以上都不是正确答案B