在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