7-22.sql

来自「包括本书所有的源代码。所有程序均在Windows 2000+IIS5.0+SQL」· SQL 代码 · 共 8 行

USE PUBS
GO
CREATE PROC GetEmployeeCount
@v_hiredate DateTime
as
Print '在输入日期之后雇佣的员工有：'
SELECT count(*) FROM Employee WHERE hire_date>@v_hiredate