extendtable.sql

来自「企业人事管理系统主要功能有： ①人事档案管理：户口状况、政治面貌、生理状况、合」· SQL 代码 · 共 1,659 行 · 第 1/5 页

values('1018','2006-5-2','旷到','无','无','无')
insert into ExtendTable
values('1018','2006-5-3','正常','有','先进个人','无')
insert into ExtendTable
values('1018','2006-5-4','正常','有','无','物流技能培训')
insert into ExtendTable
values('1018','2006-5-5','正常','有','无','无')
insert into ExtendTable
values('1018','2006-5-6','正常','无','无','无')
insert into ExtendTable
values('1018','2006-5-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1018','2006-5-8','出差','无','无','无')
insert into ExtendTable
values('1018','2006-5-9','迟到','有','泄露机密罚款','无')
insert into ExtendTable
values('1018','2006-5-10','正常','有','无','无')

insert into ExtendTable
values('1019','2006-5-1','迟到','无','无','无')
insert into ExtendTable
values('1019','2006-5-2','旷到','无','无','无')
insert into ExtendTable
values('1019','2006-5-3','正常','有','先进个人','无')
insert into ExtendTable
values('1019','2006-5-4','正常','有','无','无')
insert into ExtendTable
values('1019','2006-5-5','正常','有','无','无')
insert into ExtendTable
values('1019','2006-5-6','正常','无','无','无')
insert into ExtendTable
values('1019','2006-5-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1019','2006-5-8','出差','无','无','无')
insert into ExtendTable
values('1019','2006-5-9','迟到','有','无','无')
insert into ExtendTable
values('1019','2006-5-10','正常','有','无','物流技能培训')

insert into ExtendTable
values('1020','2006-5-1','迟到','无','无','无')
insert into ExtendTable
values('1020','2006-5-2','旷到','无','无','无')
insert into ExtendTable
values('1020','2006-5-3','正常','有','先进个人','无')
insert into ExtendTable
values('1020','2006-5-4','正常','有','无','无')
insert into ExtendTable
values('1020','2006-5-5','正常','有','无','无')
insert into ExtendTable
values('1020','2006-5-6','正常','无','无','无')
insert into ExtendTable
values('1020','2006-5-7','迟到','无','无','无')
insert into ExtendTable
values('1020','2006-5-8','出差','无','无','无')
insert into ExtendTable
values('1020','2006-5-9','迟到','有','无','无')
insert into ExtendTable
values('1020','2006-5-10','正常','有','无','无')

insert into ExtendTable
values('1021','2006-5-1','迟到','无','无','无')
insert into ExtendTable
values('1021','2006-5-2','旷到','无','无','无')
insert into ExtendTable
values('1021','2006-5-3','正常','有','无','无')
insert into ExtendTable
values('1021','2006-5-4','正常','有','无','无')
insert into ExtendTable
values('1021','2006-5-5','正常','有','无','无')
insert into ExtendTable
values('1021','2006-5-6','正常','无','无','无')
insert into ExtendTable
values('1021','2006-5-7','迟到','无','无','无')
insert into ExtendTable
values('1021','2006-5-8','出差','无','无','无')
insert into ExtendTable
values('1021','2006-5-9','迟到','有','无','领导技能培训')
insert into ExtendTable
values('1021','2006-5-10','正常','有','无','无')

insert into ExtendTable
values('1022','2006-5-1','迟到','无','无','无')
insert into ExtendTable
values('1022','2006-5-2','旷到','无','无','无')
insert into ExtendTable
values('1022','2006-5-3','正常','有','无','无')
insert into ExtendTable
values('1022','2006-5-4','正常','有','无','无')
insert into ExtendTable
values('1022','2006-5-5','正常','有','无','无')
insert into ExtendTable
values('1022','2006-5-6','正常','无','无','无')
insert into ExtendTable
values('1022','2006-5-7','迟到','无','无','无')
insert into ExtendTable
values('1022','2006-5-8','出差','无','无','无')
insert into ExtendTable
values('1022','2006-5-9','迟到','有','无','无')
insert into ExtendTable
values('1022','2006-5-10','正常','有','无','无')

insert into ExtendTable
values('1023','2006-5-1','迟到','无','无','无')
insert into ExtendTable
values('1023','2006-5-2','旷到','无','无','无')
insert into ExtendTable
values('1023','2006-5-3','正常','有','无','无')
insert into ExtendTable
values('1023','2006-5-4','正常','有','无','无')
insert into ExtendTable
values('1023','2006-5-5','正常','有','无','无')
insert into ExtendTable
values('1023','2006-5-6','正常','无','无','无')
insert into ExtendTable
values('1023','2006-5-7','迟到','无','无','无')
insert into ExtendTable
values('1023','2006-5-8','出差','无','无','无')
insert into ExtendTable
values('1023','2006-5-9','迟到','有','无','无')
insert into ExtendTable
values('1023','2006-5-10','正常','有','无','领导技能培训')


insert into ExtendTable
values('1001','2005-5-1','迟到','无','无','无')
insert into ExtendTable
values('1001','2005-5-2','旷到','无','无','无')
insert into ExtendTable
values('1001','2005-5-3','正常','有','先进个人','无')
insert into ExtendTable
values('1001','2005-5-4','正常','有','无','无')
insert into ExtendTable
values('1001','2005-5-5','正常','有','无','无')
insert into ExtendTable
values('1001','2005-5-6','正常','无','无','人事技能培训')
insert into ExtendTable
values('1001','2005-5-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1001','2005-5-8','出差','无','无','无')
insert into ExtendTable
values('1001','2005-5-9','迟到','有','无','无')
insert into ExtendTable
values('1001','2005-5-10','正常','有','无','无')

insert into ExtendTable
values('1002','2005-5-1','迟到','无','无','无')
insert into ExtendTable
values('1002','2005-5-2','旷到','无','无','无')
insert into ExtendTable
values('1002','2005-5-3','正常','有','先进个人','无')
insert into ExtendTable
values('1002','2005-5-4','正常','有','无','无')
insert into ExtendTable
values('1002','2005-5-5','正常','有','无','无')
insert into ExtendTable
values('1002','2005-5-6','正常','无','无','人事技能培训')
insert into ExtendTable
values('1002','2005-5-7','迟到','无','无','无')
insert into ExtendTable
values('1002','2005-5-8','出差','无','无','无')
insert into ExtendTable
values('1002','2005-5-9','迟到','有','泄露机密罚款','无')
insert into ExtendTable
values('1002','2005-5-10','正常','有','无','无')

insert into ExtendTable
values('1003','2005-5-1','迟到','无','无','无')
insert into ExtendTable
values('1003','2005-5-2','旷到','无','无','无')
insert into ExtendTable
values('1003','2005-5-3','正常','有','先进个人','无')
insert into ExtendTable
values('1003','2005-5-4','正常','有','无','无')
insert into ExtendTable
values('1003','2005-5-5','正常','有','无','无')
insert into ExtendTable
values('1003','2005-5-6','迟到','无','无','无')
insert into ExtendTable
values('1003','2005-5-7','迟到','无','无','无')
insert into ExtendTable
values('1003','2005-5-8','正常','无','无','无')
insert into ExtendTable
values('1003','2005-5-9','迟到','有','无','无')
insert into ExtendTable
values('1003','2005-5-10','正常','有','无','人事技能培训')

insert into ExtendTable
values('1004','2005-5-1','迟到','无','无','无')
insert into ExtendTable
values('1004','2005-5-2','旷到','无','无','无')
insert into ExtendTable
values('1004','2005-5-3','正常','有','先进个人','无')
insert into ExtendTable
values('1004','2005-5-4','正常','有','无','无')
insert into ExtendTable
values('1004','2005-5-5','正常','有','无','人事技能培训')
insert into ExtendTable
values('1004','2005-5-6','正常','无','无','无')
insert into ExtendTable
values('1004','2005-5-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1004','2005-5-8','出差','无','无','无')
insert into ExtendTable
values('1004','2005-5-9','迟到','有','无','无')
insert into ExtendTable
values('1004','2005-5-10','正常','有','无','无')

insert into ExtendTable
values('1005','2005-5-1','迟到','无','无','无')
insert into ExtendTable
values('1005','2005-5-2','旷到','无','无','无')
insert into ExtendTable
values('1005','2005-5-3','正常','有','先进个人','无')
insert into ExtendTable
values('1005','2005-5-4','正常','有','无','无')
insert into ExtendTable
values('1005','2005-5-5','正常','有','无','无')
insert into ExtendTable
values('1005','2005-5-6','正常','无','无','无')
insert into ExtendTable
values('1005','2005-5-7','正常','无','无','无')
insert into ExtendTable
values('1005','2005-5-8','出差','无','无','无')
insert into ExtendTable
values('1005','2005-5-9','迟到','有','无','无')
insert into ExtendTable
values('1005','2005-5-10','正常','有','无','人事技能培训')

insert into ExtendTable
values('1006','2005-5-1','迟到','无','无','无')
insert into ExtendTable
values('1006','2005-5-2','旷到','无','无','无')
insert into ExtendTable
values('1006','2005-5-3','正常','有','无','无')
insert into ExtendTable
values('1006','2005-5-4','正常','有','无','无')
insert into ExtendTable
values('1006','2005-5-5','正常','有','先进个人','无')
insert into ExtendTable
values('1006','2005-5-6','正常','无','无','无')
insert into ExtendTable
values('1006','2005-5-7','迟到','无','无','无')
insert into ExtendTable
values('1006','2005-5-8','出差','无','无','无')
insert into ExtendTable
values('1006','2005-5-9','迟到','有','泄露机密罚款','无')
insert into ExtendTable
values('1006','2005-5-10','正常','有','无','维护技能培训')

insert into ExtendTable
values('1007','2005-5-1','迟到','无','无','无')
insert into ExtendTable
values('1007','2005-5-2','旷到','无','无','无')
insert into ExtendTable
values('1007','2005-5-3','正常','有','先进个人','无')
insert into ExtendTable
values('1007','2005-5-4','正常','有','无','无')
insert into ExtendTable
values('1007','2005-5-5','正常','有','无','无')
insert into ExtendTable
values('1007','2005-5-6','正常','无','无','无')
insert into ExtendTable
values('1007','2005-5-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1007','2005-5-8','出差','无','无','无')
insert into ExtendTable
values('1007','2005-5-9','迟到','有','无','维护技能培训')
insert into ExtendTable
values('1007','2005-5-10','正常','有','无','无')

insert into ExtendTable
values('1008','2005-5-1','迟到','无','无','无')
insert into ExtendTable
values('1008','2005-5-2','旷到','无','无','无')
insert into ExtendTable
values('1008','2005-5-3','正常','有','先进个人','无')
insert into ExtendTable
values('1008','2005-5-4','正常','有','无','无')
insert into ExtendTable
values('1008','2005-5-5','正常','有','无','无')
insert into ExtendTable
values('1008','2005-5-6','正常','无','无','无')
insert into ExtendTable
values('1008','2005-5-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1008','2005-5-8','出差','无','无','维护技能培训')
insert into ExtendTable
values('1008','2005-5-9','迟到','有','无','无')
insert into ExtendTable
values('1008','2005-5-10','正常','有','无','无')

insert into ExtendTable
values('1009','2005-5-1','迟到','无','无','无')
insert into ExtendTable
values('1009','2005-5-2','旷到','无','无','无')
insert into ExtendTable
values('1009','2005-5-3','正常','有','先进个人','无')
insert into ExtendTable
values('1009','2005-5-4','正常','有','无','无')
insert into ExtendTable
values('1009','2005-5-5','正常','有','无','无')
insert into ExtendTable
values('1009','2005-5-6','正常','无','无','无')
insert into ExtendTable
values('1009','2005-5-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1009','2005-5-8','出差','无','无','无')
insert into ExtendTable
values('1009','2005-5-9','迟到','有','无','无')
insert into ExtendTable
values('1009','2005-5-10','正常','有','无','维护技能培训')

insert into ExtendTable
values('1010','2005-5-1','迟到','无','无','无')
insert into ExtendTable
values('1010','2005-5-2','旷到','无','无','无')
insert into ExtendTable
values('1010','2005-5-3','正常','有','先进个人','无')
insert into ExtendTable
values('1010','2005-5-4','正常','有','无','维护技能培训')
insert into ExtendTable
values('1010','2005-5-5','正常','有','无','无')
insert into ExtendTable
values('1010','2005-5-6','正常','无','无','无')
insert into ExtendTable
values('1010','2005-5-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1010','2005-5-8','出差','无','无','无')
insert into ExtendTable
values('1010','2005-5-9','迟到','有','泄露