用于创建测试例例数据和测试结果存储的脚本：
--==========================
--makeDbEmployees.sql
use master
go
if exists(select * from sysdatabases where name = 'dbEmployees')
drop database dbEmployees
go
if exists(select * from sysxlogins where name = 'employeesLogin')
exec sp_droplogin 'employeesLogin'
go
create database dbEmployees
go
use dbEmployees
go
create table tb1Employees
(
empID char(3) primary key,
empLast varchar(35) not null,
empDOH datetime not null,
)
go
insert into tb1Employees values('e11','Adams','10/25/2009')
insert into tb1Employees values('e22','Baker','10/25/2009')
go
exec sp_addlogin 'employeesLogin','secret'
go
exec sp_grantdbaccess 'employeesLogin'
go
create procedure usp_HiredAfter
@dt datetime
as
select * from tb1Employees where empDOH > @dt
go
grant execute on usp_HiredAfter to employeesLogin
go
--end script
--makeDbEmployees.sql
use master
go
if exists(select * from sysdatabases where name = 'dbEmployees')
drop database dbEmployees
go
if exists(select * from sysxlogins where name = 'employeesLogin')
exec sp_droplogin 'employeesLogin'
go
create database dbEmployees
go
use dbEmployees
go
create table tb1Employees
(
empID char(3) primary key,
empLast varchar(35) not null,
empDOH datetime not null,
)
go
insert into tb1Employees values('e11','Adams','10/25/2009')
insert into tb1Employees values('e22','Baker','10/25/2009')
go
exec sp_addlogin 'employeesLogin','secret'
go
exec sp_grantdbaccess 'employeesLogin'
go
create procedure usp_HiredAfter
@dt datetime
as
select * from tb1Employees where empDOH > @dt
go
grant execute on usp_HiredAfter to employeesLogin
go
--end script
