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

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

insert into monthlysalary values('000001',     4000.00,'04/01/2000',0)
insert into monthlysalary values('000001',     4000.00,'05/01/2000',0)
insert into monthlysalary values('000001',     4000.00,'06/01/2000',0)
insert into monthlysalary values('000001',     4000.00,'07/01/2000',0)
-------------------------------------------------------------------- 
insert into monthlysalary values('000002',     3000.00,'07/01/2000',0)
insert into monthlysalary values('000004',     4000.00,'07/01/2000',0)
insert into monthlysalary values('000005',     4000.00,'07/01/2000',0)
-------------------------------------------------------------------- 
insert into monthlysalary values('000001',     4000.00,'08/01/2000',0)
insert into monthlysalary values('000002',     3000.00,'08/01/2000',0)
insert into monthlysalary values('000004',     4000.00,'08/01/2000',0)
insert into monthlysalary values('000005',     4000.00,'08/01/2000',0)
insert into monthlysalary values('000006',     4000.00,'08/01/2000',0)
-------------------------------------------------------------------- 
insert into monthlysalary values('000001',     4000.00,'09/01/2000',0)
insert into monthlysalary values('000002',     3000.00,'09/01/2000',0)
insert into monthlysalary values('000004',     4000.00,'09/01/2000',0)
insert into monthlysalary values('000005',     4000.00,'09/01/2000',0)
insert into monthlysalary values('000006',     4000.00,'09/01/2000',0)
insert into monthlysalary values('000007',     2000.00,'09/01/2000',0)
insert into monthlysalary values('000008',     2000.00,'09/01/2000',0)
-------------------------------------------------------------------- 
insert into monthlysalary values('000001',     4000.00,'10/01/2000',0)
insert into monthlysalary values('000002',     3000.00,'10/01/2000',0)
insert into monthlysalary values('000004',     4000.00,'10/01/2000',0)
insert into monthlysalary values('000005',     4000.00,'10/01/2000',0)
insert into monthlysalary values('000006',     4000.00,'10/01/2000',0)
insert into monthlysalary values('000007',     2000.00,'10/01/2000',0)
insert into monthlysalary values('000008',     2000.00,'10/01/2000',0)
insert into monthlysalary values('000009',     2500.00,'10/01/2000',0)
insert into monthlysalary values('000010',     2000.00,'10/01/2000',0)
insert into monthlysalary values('000011',     2000.00,'10/01/2000',0)
insert into monthlysalary values('000012',     3000.00,'10/01/2000',0)
-------------------------------------------------------------------- 
insert into monthlysalary values('000001',     4000.00,'11/01/2000',0)
insert into monthlysalary values('000002',     3000.00,'11/01/2000',0)
insert into monthlysalary values('000004',     4000.00,'11/01/2000',0)
insert into monthlysalary values('000005',     4000.00,'11/01/2000',0)
insert into monthlysalary values('000006',     4000.00,'11/01/2000',0)
insert into monthlysalary values('000007',     2000.00,'11/01/2000',0)
insert into monthlysalary values('000008',     2000.00,'11/01/2000',0)
insert into monthlysalary values('000009',     2500.00,'11/01/2000',0)
insert into monthlysalary values('000010',     2000.00,'11/01/2000',0)
insert into monthlysalary values('000011',     2000.00,'11/01/2000',0)
insert into monthlysalary values('000012',     3000.00,'11/01/2000',0)
insert into monthlysalary values('000013',     4000.00,'11/01/2000',0)
insert into monthlysalary values('000014',     3000.00,'11/01/2000',0)
-------------------------------------------------------------------- 
insert into monthlysalary values('000001',     4000.00,'12/01/2000',0)
insert into monthlysalary values('000002',     3000.00,'12/01/2000',0)
insert into monthlysalary values('000004',     4000.00,'12/01/2000',0)
insert into monthlysalary values('000005',     4000.00,'12/01/2000',0)
insert into monthlysalary values('000006',     4000.00,'12/01/2000',0)
insert into monthlysalary values('000007',     2000.00,'12/01/2000',0)
insert into monthlysalary values('000008',     2000.00,'12/01/2000',0)
insert into monthlysalary values('000009',     2500.00,'12/01/2000',0)
insert into monthlysalary values('000010',     2000.00,'12/01/2000',0)
insert into monthlysalary values('000011',     2000.00,'12/01/2000',0)
insert into monthlysalary values('000012',     3000.00,'12/01/2000',0)
insert into monthlysalary values('000013',     4000.00,'12/01/2000',0)
insert into monthlysalary values('000014',     3000.00,'12/01/2000',0)
insert into monthlysalary values('000015',     2000.00,'12/01/2000',0)
-------------------------------------------------------------------- 
insert into monthlysalary values('000001',     4000.00,'01/01/2001',0)
insert into monthlysalary values('000002',     3000.00,'01/01/2001',0)
insert into monthlysalary values('000004',     4000.00,'01/01/2001',0)
insert into monthlysalary values('000005',     4000.00,'01/01/2001',0)
insert into monthlysalary values('000006',     4000.00,'01/01/2001',0)
insert into monthlysalary values('000007',     2000.00,'01/01/2001',0)
insert into monthlysalary values('000008',     2000.00,'01/01/2001',0)
insert into monthlysalary values('000009',     2500.00,'01/01/2001',0)
insert into monthlysalary values('000010',     2000.00,'01/01/2001',0)
insert into monthlysalary values('000011',     2000.00,'01/01/2001',0)
insert into monthlysalary values('000012',     3000.00,'01/01/2001',0)
insert into monthlysalary values('000013',     4000.00,'01/01/2001',0)
insert into monthlysalary values('000014',     3000.00,'01/01/2001',0)
insert into monthlysalary values('000015',     2000.00,'01/01/2001',0)
-------------------------------------------------------------------- 
insert into monthlysalary values('000001',     4000.00,'02/01/2001',0)
insert into monthlysalary values('000002',     3000.00,'02/01/2001',0)
insert into monthlysalary values('000004',     4000.00,'02/01/2001',0)
insert into monthlysalary values('000005',     4000.00,'02/01/2001',0)
insert into monthlysalary values('000006',     4000.00,'02/01/2001',0)
insert into monthlysalary values('000007',     2000.00,'02/01/2001',0)
insert into monthlysalary values('000008',     2000.00,'02/01/2001',0)
insert into monthlysalary values('000009',     2500.00,'02/01/2001',0)
insert into monthlysalary values('000010',     2000.00,'02/01/2001',0)
insert into monthlysalary values('000011',     2000.00,'02/01/2001',0)
insert into monthlysalary values('000012',     3000.00,'02/01/2001',0)
insert into monthlysalary values('000013',     4000.00,'02/01/2001',0)
insert into monthlysalary values('000014',     3000.00,'02/01/2001',0)
insert into monthlysalary values('000015',     2000.00,'02/01/2001',0)
-------------------------------------------------------------------- 
insert into monthlysalary values('000001',     4000.00,'03/01/2001',0)
insert into monthlysalary values('000002',     3000.00,'03/01/2001',0)
insert into monthlysalary values('000004',     4000.00,'03/01/2001',0)
insert into monthlysalary values('000005',     4000.00,'03/01/2001',0)
insert into monthlysalary values('000006',     4000.00,'03/01/2001',0)
insert into monthlysalary values('000007',     2000.00,'03/01/2001',0)
insert into monthlysalary values('000008',     2000.00,'03/01/2001',0)
insert into monthlysalary values('000009',     2500.00,'03/01/2001',0)
insert into monthlysalary values('000010',     2000.00,'03/01/2001',0)
insert into monthlysalary values('000011',     2000.00,'03/01/2001',0)
insert into monthlysalary values('000012',     3000.00,'03/01/2001',0)
insert into monthlysalary values('000013',     4000.00,'03/01/2001',0)
insert into monthlysalary values('000014',     3000.00,'03/01/2001',0)
insert into monthlysalary values('000015',     2000.00,'03/01/2001',0)
-------------------------------------------------------------------- 
insert into monthlysalary values('000001',     4000.00,'04/01/2001',0)
insert into monthlysalary values('000002',     3000.00,'04/01/2001',0)
insert into monthlysalary values('000004',     4000.00,'04/01/2001',0)
insert into monthlysalary values('000005',     4000.00,'04/01/2001',0)
insert into monthlysalary values('000006',     4000.00,'04/01/2001',0)
insert into monthlysalary values('000007',     2000.00,'04/01/2001',0)
insert into monthlysalary values('000008',     2000.00,'04/01/2001',0)
insert into monthlysalary values('000009',     2500.00,'04/01/2001',0)
insert into monthlysalary values('000010',     2000.00,'04/01/2001',0)
insert into monthlysalary values('000011',     2000.00,'04/01/2001',0)
insert into monthlysalary values('000012',     3000.00,'04/01/2001',0)
insert into monthlysalary values('000013',     4000.00,'04/01/2001',0)
insert into monthlysalary values('000014',     3000.00,'04/01/2001',0)
insert into monthlysalary values('000015',     2000.00,'04/01/2001',0)
-------------------------------------------------------------------- 
insert into monthlysalary values('000001',     4000.00,'05/01/2001',0)
insert into monthlysalary values('000002',     3000.00,'05/01/2001',0)
insert into monthlysalary values('000004',     4000.00,'05/01/2001',0)
insert into monthlysalary values('000005',     4000.00,'05/01/2001',0)
insert into monthlysalary values('000006',     4000.00,'05/01/2001',0)
insert into monthlysalary values('000007',     2000.00,'05/01/2001',0)
insert into monthlysalary values('000008',     2000.00,'05/01/2001',0)
insert into monthlysalary values('000009',     2500.00,'05/01/2001',0)
insert into monthlysalary values('000010',     2000.00,'05/01/2001',0)
insert into monthlysalary values('000011',     2000.00,'05/01/2001',0)
insert into monthlysalary values('000012',     3000.00,'05/01/2001',0)
insert into monthlysalary values('000013',     4000.00,'05/01/2001',0)
insert into monthlysalary values('000014',     3000.00,'05/01/2001',0)
insert into monthlysalary values('000015',     2000.00,'05/01/2001',0)
-------------------------------------------------------------------- 
insert into monthlysalary values('000001',     4000.00,'06/01/2001',0)
insert into monthlysalary values('000002',     3000.00,'06/01/2001',0)
insert into monthlysalary values('000004',     4000.00,'06/01/2001',0)
insert into monthlysalary values('000005',     4000.00,'06/01/2001',0)
insert into monthlysalary values('000006',     4000.00,'06/01/2001',0)
insert into monthlysalary values('000007',     2000.00,'06/01/2001',0)
insert into monthlysalary values('000008',     2000.00,'06/01/2001',0)
insert into monthlysalary values('000009',     2500.00,'06/01/2001',0)
insert into monthlysalary values('000010',     2000.00,'06/01/2001',0)
insert into monthlysalary values('000011',     2000.00,'06/01/2001',0)
insert into monthlysalary values('000012',     3000.00,'06/01/2001',0)
insert into monthlysalary values('000013',     4000.00,'06/01/2001',0)
insert into monthlysalary values('000014',     3000.00,'06/01/2001',0)
insert into monthlysalary values('000015',     2000.00,'06/01/2001',0)
go

raiserror('插入数据到 EmployeeSkill 表....',0,1)
insert into employeeskill  values('000001','0001')
insert into employeeskill  values('000001','0006')
insert into employeeskill  values('000001','0009')
insert into employeeskill  values('000001','0010')
insert into employeeskill  values('000001','0012')
insert into employeeskill  values('000001','0015')
insert into employeeskill  values('000001','0018')
insert into employeeskill  values('000001','0020')
insert into employeeskill  values('000001','0021')
insert into employeeskill  values('000001','0013')
--  
insert into employeeskill  values('000002','0001')
insert into employeeskill  values('000002','0009')
insert into employeeskill  values('000002','0010')
insert into employeeskill  values('000002','0012')
insert into employeeskill  values('000002','0015')
insert into employeeskill  values('000002','0018')
--
insert into employeeskill  values('000003','0001')
insert into employeeskill  values('000003','0006')
insert into employeeskill  values('000003','0016')
insert into employeeskill  values('000003','0020')
--
insert into employeeskill  values('000004','0001')
insert into employeeskill  values('000004','0006')
insert into employeeskill  values('000004','0009')
insert into employeeskill  values('000004','0010')
insert into employeeskill  values('000004','0012')
insert into employeeskill  values('000004','0015')
insert into employeeskill  values('000004','0018')
insert into employeeskill  values('000004','0020')
insert into employeeskill  values('000004','0021')
insert into employeeskill  values('000004','0013')
--
insert into employeeskill  values('000005','0001')
insert into employeeskill  values('000005','0006')
insert into employeeskill  values('000005','0009')
insert into employeeskill  values('000005','0010')
insert into employeeskill  values('000005','0012')
insert into employeeskill  values('000005','0015')
insert into employeeskill  values('000005','0018')
insert into employeeskill  values('000005','0020')
insert into employeeskill  values('000005','0021')
insert into employeeskill  values('000005','0013')
--
insert into employeeskill  values('000006','0001')
insert into employeeskill  values('000006','0006')
insert into employeeskill  values('000006','0009')
insert into employeeskill  values('000006','0010')