1.1_创建studydb1数据库中的表.sql

这是我在学习《SQL Server数据库系统结构基础》时所用到的一个脚本文件

insert into employeeskill  values('000006','0012')
insert into employeeskill  values('000006','0015')
insert into employeeskill  values('000006','0018')
insert into employeeskill  values('000006','0020')
insert into employeeskill  values('000006','0021')
insert into employeeskill  values('000006','0013')
--
insert into employeeskill  values('000007','0001')
insert into employeeskill  values('000007','0016')
insert into employeeskill  values('000007','0020')
--
insert into employeeskill  values('000008','0001')
insert into employeeskill  values('000008','0016')
insert into employeeskill  values('000008','0020')
--
insert into employeeskill  values('000009','0001')
insert into employeeskill  values('000009','0018')
insert into employeeskill  values('000009','0017')
insert into employeeskill  values('000009','0020')
--
insert into employeeskill  values('000010','0001')
insert into employeeskill  values('000010','0016')
insert into employeeskill  values('000010','0020')
--
insert into employeeskill  values('000011','0001')
insert into employeeskill  values('000011','0016')
insert into employeeskill  values('000011','0020')
insert into employeeskill  values('000011','0014')
insert into employeeskill  values('000011','0008')
--
insert into employeeskill  values('000012','0001')
insert into employeeskill  values('000012','0006')
insert into employeeskill  values('000012','0009')
insert into employeeskill  values('000012','0010')
insert into employeeskill  values('000012','0012')
insert into employeeskill  values('000012','0015')
insert into employeeskill  values('000012','0018')
insert into employeeskill  values('000012','0020')
insert into employeeskill  values('000012','0021')
insert into employeeskill  values('000012','0013')
--
insert into employeeskill  values('000013','0001')
insert into employeeskill  values('000013','0006')
insert into employeeskill  values('000013','0009')
insert into employeeskill  values('000013','0010')
insert into employeeskill  values('000013','0012')
insert into employeeskill  values('000013','0015')
insert into employeeskill  values('000013','0018')
insert into employeeskill  values('000013','0020')
insert into employeeskill  values('000013','0021')
insert into employeeskill  values('000013','0013')
--
insert into employeeskill  values('000014','0001')
insert into employeeskill  values('000014','0006')
insert into employeeskill  values('000014','0009')
insert into employeeskill  values('000014','0010')
insert into employeeskill  values('000014','0012')
insert into employeeskill  values('000014','0015')
insert into employeeskill  values('000014','0018')
insert into employeeskill  values('000014','0020')
insert into employeeskill  values('000014','0021')
insert into employeeskill  values('000014','0013')
--
insert into employeeskill  values('000015','0001')
insert into employeeskill  values('000015','0016')
insert into employeeskill  values('000015','0020')
go

raiserror('插入数据到 CandidateSkill 表....',0,1)
insert into candidateskill values('000001','0001')
insert into candidateskill values('000001','0006')
insert into candidateskill values('000001','0009')
insert into candidateskill values('000001','0010')
insert into candidateskill values('000001','0012')
insert into candidateskill values('000001','0013')
insert into candidateskill values('000001','0015')
insert into candidateskill values('000001','0018')
insert into candidateskill values('000001','0020')
insert into candidateskill values('000001','0021')
insert into candidateskill values('000003','0001')
insert into candidateskill values('000003','0009')
insert into candidateskill values('000003','0010')
insert into candidateskill values('000003','0012')
insert into candidateskill values('000003','0015')
insert into candidateskill values('000003','0018')
insert into candidateskill values('000004','0001')
insert into candidateskill values('000004','0006')
insert into candidateskill values('000004','0016')
insert into candidateskill values('000004','0020')
insert into candidateskill values('000005','0001')
insert into candidateskill values('000005','0006')
insert into candidateskill values('000005','0009')
insert into candidateskill values('000005','0010')
insert into candidateskill values('000005','0012')
insert into candidateskill values('000005','0013')
insert into candidateskill values('000005','0015')
insert into candidateskill values('000005','0018')
insert into candidateskill values('000005','0020')
insert into candidateskill values('000005','0021')
insert into candidateskill values('000010','0001')
insert into candidateskill values('000010','0006')
insert into candidateskill values('000010','0009')
insert into candidateskill values('000010','0010')
insert into candidateskill values('000010','0012')
insert into candidateskill values('000010','0013')
insert into candidateskill values('000010','0015')
insert into candidateskill values('000010','0018')
insert into candidateskill values('000010','0020')
insert into candidateskill values('000010','0021')
insert into candidateskill values('000014','0001')
insert into candidateskill values('000014','0006')
insert into candidateskill values('000014','0009')
insert into candidateskill values('000014','0010')
insert into candidateskill values('000014','0012')
insert into candidateskill values('000014','0013')
insert into candidateskill values('000014','0015')
insert into candidateskill values('000014','0018')
insert into candidateskill values('000014','0020')
insert into candidateskill values('000014','0021')
insert into candidateskill values('000016','0001')
insert into candidateskill values('000016','0016')
insert into candidateskill values('000016','0020')
insert into candidateskill values('000018','0001')
insert into candidateskill values('000018','0016')
insert into candidateskill values('000018','0020')
insert into candidateskill values('000026','0001')
insert into candidateskill values('000026','0017')
insert into candidateskill values('000026','0018')
insert into candidateskill values('000026','0020')
insert into candidateskill values('000029','0001')
insert into candidateskill values('000029','0016')
insert into candidateskill values('000029','0020')
insert into candidateskill values('000035','0001')
insert into candidateskill values('000035','0008')
insert into candidateskill values('000035','0014')
insert into candidateskill values('000035','0016')
insert into candidateskill values('000035','0020')
insert into candidateskill values('000039','0001')
insert into candidateskill values('000039','0006')
insert into candidateskill values('000039','0009')
insert into candidateskill values('000039','0010')
insert into candidateskill values('000039','0012')
insert into candidateskill values('000039','0013')
insert into candidateskill values('000039','0015')
insert into candidateskill values('000039','0018')
insert into candidateskill values('000039','0020')
insert into candidateskill values('000039','0021')
insert into candidateskill values('000045','0001')
insert into candidateskill values('000045','0006')
insert into candidateskill values('000045','0009')
insert into candidateskill values('000045','0010')
insert into candidateskill values('000045','0012')
insert into candidateskill values('000045','0013')
insert into candidateskill values('000045','0015')
insert into candidateskill values('000045','0018')
insert into candidateskill values('000045','0020')
insert into candidateskill values('000045','0021')
insert into candidateskill values('000046','0001')
insert into candidateskill values('000046','0006')
insert into candidateskill values('000046','0009')
insert into candidateskill values('000046','0010')
insert into candidateskill values('000046','0012')
insert into candidateskill values('000046','0013')
insert into candidateskill values('000046','0015')
insert into candidateskill values('000046','0018')
insert into candidateskill values('000046','0020')
insert into candidateskill values('000046','0021')
insert into candidateskill values('000047','0001')
insert into candidateskill values('000047','0016')
insert into candidateskill values('000047','0020')
go

raiserror('插入数据到 Position 表....',0,1)
insert into positionskill values('0001','0001')
insert into positionskill values('0001','0006')
insert into positionskill values('0002','0001')
insert into positionskill values('0002','0006')
insert into positionskill values('0003','0001')
insert into positionskill values('0004','0001')
insert into positionskill values('0004','0002')
insert into positionskill values('0004','0003')
insert into positionskill values('0004','0005')
insert into positionskill values('0004','0006')
insert into positionskill values('0005','0001')
insert into positionskill values('0005','0005')
insert into positionskill values('0005','0006')
insert into positionskill values('0006','0001')
go

raiserror('插入数据到 EmployeeReferral 表....',0,1)
insert into employeereferrals values('000001','000001','000021')
insert into employeereferrals values('000002','000002','000018')
insert into employeereferrals values('000003','000001','000014')
go
raiserror('插入数据到 Requisition 表....',0,1)

INSERT into Requisition 
VALUES('000001','0003','03/03/01','04/04/01','0009','Texas',10)
INSERT into Requisition 
VALUES('000002','0002','05/06/01','06/07/01','0002','Texas',11)
INSERT into Requisition 
VALUES('000004','0015',getdate(),getdate()+7,'0003','Texas',12)
raiserror('用户数据库和表已经创建完成...',0,1)