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

来自「这是我在学习《SQL Server数据库系统结构基础》时所用到的一个脚本文件」· SQL 代码 · 共 1,024 行 · 第 1/5 页

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')