定单表Orders的列OrderID的类型是smallint,根据业务的发展需要改为int,应该使用下面的()语句。
ALTER COLUMN OrderID int FROM Orders
B. ALTER COLUMN Orders.OrderID int
C. ALTER TABLE Orders ( OrderID int )
D. ALTER TABLE Orders ALTER COLUMN OrderID int
查看答案
查询从2001年1月1日到2001年12月31日雇佣的所有职员的姓名和雇佣日期,职员信息表tblEmployees包含列Name和列HireDate,下面()能完成该功能。
A. SELECT Name, HireDate FROM tblEmployees WHERE HireDate ='2001-01-01' AND '2001-12-31'
B. SELECT Name, HireDate FROM tblEmployees WHERE HireDate ='2001-01-01' OR '2001-12-31'
C. SELECT Name, HireDate FROM tblEmployees WHERE HireDate BETWEEN '2000-12-31' AND '2002-01-01'
D. SELECT Name, HireDate FROM tblEmployees WHERE DATEPART(yy, HireDate) =2001
与查询语句select * from student where sage> (select max(sage) from student where ssex='女')等价的是()。
A. select * from student where sage>any(select sage from student where ssex ='女')
B. select * from student where sage >(select sage from student where ssex ='女')
C. select * from student where sage >all(select sage from student where ssex ='女')
D. select * from student where sage in(select sage from student where ssex ='女')
查询中的where子句与having子句功能完全相同,二者可以通用。
A. 对
B. 错
条件“职称 in ('教授', '副教授')”与“职称 = '教授' or 职称 = '副教授'”等价。
A. 对
B. 错
微信支付 
支付宝支付