第1章 数据库基础
1. 答案:⑴ A,⑵ B。(课本: 1.2.1)
2. 答案:A。(课本: 1.2.5)
3. 答案:B。(课本: 1.2.5)
4. 答案:B。(课本: 1.2.7)
5. 答案:
SELECT * FROM 销售表
WHERE (selldate >= '2002-2-15' AND selldate <='2002-4-29')
AND deptno = '01'(课本:1.2.5)
6. 答案:
create PROCEDURE [dbo].[spGetEmployeesByID]
@EmployeeID int
AS
IF(@EmployeeID = 0)
BEGIN
SELECT 员工编号,员工姓名
FROM 员工
END
ELSE
BEGIN
SELECT 员工编号,员工姓名
FROM 员工
WHERE 员工编号= @EmployeeID
END
(课本:1.2.7)