7-22.sql

asp开发 asp开发 asp开发 asp开发

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