--==========================
--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