📄 1.1_创建studydb1数据库中的表.sql
字号:
insert into newspaper values('0002','Bussiness Journal','Norton','Bussiness','Pamela Desouza','900 N State St Norton','Norton','Kansas','76754-2219','001','(785)877-2344','(785)877-2363')
insert into newspaper values('0003','Daily News','Mentor','General','Jack Miller','4896 11th ST Hill Avenue','Mentor','Ohio','44060-5102','001','(440)257-2934','(440)257-2935')
insert into newspaper values('0004','Georgia Chronicle','Georgia','General','Abair Duane','4483 victory drive','Columbus','Georgia','31905-1189','001','(706)687-0686','(706)687-0688')
insert into newspaper values('0005','Nevada Update','Nevada','general','Jack Phil','7765 La Cienega St ','Las Vegas','Nevada','89123-1707','001','(702)263-0704','(702)263-0724')
insert into newspaper values('0006','Morning News','New Jersy','General','Renard Andrew','125 Shark River Rd ','Middle Town','New Jersy','07748-3325','001','(732)708-0249','(732)708-0235')
insert into newspaper values('0007','Nevada News','Nevada','General','Ray Dean','Cambridge St','Las Vegas','Nevada','89109-4072','001','(702)369-6592','(702)369-6408')
insert into newspaper values('0008','Kansas Today','Kansas','Genral','Robin Paul','1925 Shawnee Dr ','Kansas City','Kansas','66106-3025','001','(913)362-9529','(913)362-9515')
insert into newspaper values('0009','Star Texas Times','Texas','Genral','Juan Smith','322 Highway 39','Ingram','Texas','63206-3025','001','(803)432-9512','(720)342-9235')
insert into newspaper values('0010','Los Angeles News','California','Genral','Frank Robertson','123 Pier Avenue','Santa Monica','California','90423-3025','001','(303)426-2212','(303)623-6345')
insert into newspaper values('0011','Sonoma Valley News','California','Genral','John Atkinson','120 S. Main St. Suit','Sebastopol','California','97678-3224','001','(707)234-5512','(707)864-9565')
go
raiserror('插入数据到 NewsAd 表....',0,1)
insert into newsad values('0001','0003','04/03/2001','04/12/2001')
insert into newsad values('0002','0002','03/15/2001','04/12/2001')
insert into newsad values('0003','0005','04/03/2001','04/22/2001')
insert into newsad values('0004','0005','04/05/2001','04/14/2001')
insert into newsad values('0005','0005','05/06/2001','05/15/2001')
insert into newsad values('0006','0001','05/07/2001','05/16/2001')
insert into newsad values('0007','0002','06/08/2001','06/17/2001')
insert into newsad values('0008','0003','06/01/2001','06/18/2001')
insert into newsad values('0009','0002','07/02/2001','07/13/2001')
insert into newsad values('0010','0003','07/03/2001','07/14/2001')
insert into newsad values('0011','0005','07/04/2001','07/15/2001')
insert into newsad values('0012','0001','07/05/2001','07/16/2001')
insert into newsad values('0013','0002','07/06/2001','07/17/2001')
insert into newsad values('0014','0001','07/07/2001','07/18/2001')
insert into newsad values('0015','0001','07/08/2001','07/13/2001')
go
raiserror('插入数据到 JobFair 表....',0,1)
insert into jobfair values('0001','Wright State Uni.Dayton, OH','National Def. Asso.', 18,'05/11/2001')
insert into jobfair values('0002','Tulsa Mar. South Hills 1902','CFG', 20,'05/30/2001')
insert into jobfair values('0003','211 Ninian Ave Alexandria','ADF', 10,'05/25/2001')
insert into jobfair values('0004','23 Pitt Rd Spring Field Ohio','DDC', 22,'05/22/2001')
insert into jobfair values('0005','36 Mcgrath Dr Dublin','PLC', 20,'05/21/2001')
go
raiserror('插入数据到 ContractRecruiter 表....',0,1)
insert into contractrecruiter values('0001','Jack Paul','2250 Lakeside Ave.','Alexandria','Virginia','22310-1117','(703)922-2654','(703)922-2662',15,1200)
insert into contractrecruiter values('0002','Abbott Mike','3688 Mcgrath Dr','Dublin','Georgia','43016-4171','(614)761-7743','(614)761-7745',7,1500)
insert into contractrecruiter values('0003','Facundo Michel','1150 Prince St.','Alexandria','Virginia','22314-2947','(703)684-1696','(703)684-1680',9,800)
insert into contractrecruiter values('0004','Taber Kyle','1225 Effingham Ct','Columbus','Georgia','31909-3165','(706)565-9463','(706)565-9464',7,700)
insert into contractrecruiter values('0005','Joe Bryan','28 Pitt Rd','Spring Field','Ohio','07081-2634','(973)467-1682','(973)467-1682',9,900)
insert into contractrecruiter values('0006','George Craig','5202 Ninian Ave ','Alexandria','Virginia','22310-1117','(703)922-3466','(703)922-3467',9,1200)
go
raiserror('插入数据到 RecruitmentAgencies 表....',0,1)
Insert into recruitmentagencies values('0001','ASTEC Inc ','11715 Administration Dr Suite 230','Hampstead','New York','11550-3425','(516)433-1426','(516)433-1427',8, 1200)
Insert into recruitmentagencies values('0002','CDI Corporation West','9301 Oakdale Ave Suite 114 ','New Orleans','Louisinia','70131-1265','(504)422-5608','(504)422-5734', 9, 800)
Insert into recruitmentagencies values('0003','ETS Inc ','5717 E Thomas Rd Suite 3 ','New Orleans','Louisinia','70115-2365','(504)323-4322','(504)323-4342', 9, 1100)
Insert into recruitmentagencies values('0004','FSK Associates Inc ','PO Box 1078 ','Houston ','Texas','77015-4568','(713)451-2847','(713)451-2852', 6, 1200)
Insert into recruitmentagencies values('0006','Hall Kinion ','19925 Stevens Creek Blvd Suite 180','Houston','Texas','77016-3448','(713)642-7253','(713)642-7250', 8, 800)
Insert into recruitmentagencies values('0007','Manpower Technical ','517 Fifth Ave ','Alexandria','Virginia','22302-1608','(703)214-4423','(703)214-4425', 6, 1200)
Insert into recruitmentagencies values('0009','Sysdyne Corporation ','1660 S Highway 100 Suite 424 ','Cleveland','Ohio','44106-1523','(440)885-1980','(440)885-1978', 6, 800)
go
raiserror('插入数据到 College 表....',0,1)
Insert into college values('0001','Westend College ','900N Main Ave','Hampstead','New York','11550-1648','(516)423-4591')
Insert into college values('0002','Cromwell College ','4010 Gartner Ave.','Abilene','Texas','79605-4123','(915)692-6628')
Insert into college values('0003','Schneider College ','2100 New Blvd','Los Angeles','California','70131-3184','(504)271-2187')
Insert into college values('0004','Trent College ','240N Grand Ave.','Abilene','Texas','79605-4415','(915)368-2561')
Insert into college values('0005','Wiley College ','711 Wiley College','Columbus','Ohio','43220-2821','(614)451-1005')
Insert into college values('0006','Benard College ','3009 broad way','New York City','New York','10128-4018','(212)969-9826')
Insert into college values('0007','Deman College ','4380 Main Street','Hampstead ','New York','11550-4321','(516)532-3728')
Insert into college values('0008','Monterey College ','30 Emmons park drive','Taft','California','93268-1648','(661)761-4591')
Insert into college values('0009','Evergreen College ','2000 College Heights Blvd','Ridgecrest','California','93555-1648','(760)761-4591')
go
raiserror('插入数据到 CampusRecruitment 表....',0,1)
Insert into campusrecruitment values('0001','0003','05/13/2001','05/28/2001')
Insert into campusrecruitment values('0002','0005','05/23/2001','06/07/2001')
Insert into campusrecruitment values('0003','0002','05/13/2001','05/28/2001')
go
raiserror('插入数据到 InternalJobPosting 表....',0,1)
Insert into InternalJobPosting values('0001','0002',6,'New York','03/13/2001','04/12/2001')
Insert into InternalJobPosting values('0002','0004',9,'Texas','03/15/2001','04/12/2001')
Insert into InternalJobPosting values('0003','0001',7,'New York','04/02/2001','04/22/2001')
Insert into InternalJobPosting values('0004','0002',12,'Texas','03/13/2001','04/12/2001')
Insert into InternalJobPosting values('0005','0004',2,'New York','03/13/2000','04/12/2000')
Insert into InternalJobPosting values('0006','0002',4,'New York','03/13/2000','04/12/2000')
go
raiserror('插入数据到 InternalCandidate 表....',0,1)
Insert into InternalCandidate values('000001','000012','0001','0002','04/02/2001','04/06/2001',96,'04/09/2001',null,null,'5',null)
Insert into InternalCandidate values('000002','000002','0001','0002','04/02/2001','04/06/2001',67,'04/09/2001',null,null,'6',null)
Insert into InternalCandidate values('000003','000011','0003','0001','04/02/2001','04/06/2001',88,'04/09/2001',null,null,'9',null)
Insert into InternalCandidate values('000004','000002','0003','0001','04/02/2001','04/06/2001',83,'04/09/2001',null,null,'7',null)
Insert into InternalCandidate values('000005','000008','0001','0002','04/02/2001','04/06/2001',43,'04/09/2001',null,null,'3',null)
Insert into InternalCandidate values('000018','000003','0001','0002','02/02/2001','03/06/2001',null,'04/09/2001',null,null,'8',null)
go
raiserror('插入数据到 ExternalCandidate 表....',0,1)
insert into externalcandidate values('000001','Angela','Smith','16223 Radiance Court','Kansas City ','Kansas','66101-2945','001','(913)227-2344 ','0001','05/02/2001',null,'0001',null,null,null,null,null ,'Graduate',4 ,'2/12/1969','F','0001', 30000.00,null,'angelas@qmail.com','P','05/09/97',80,'05/15/97',null,null,8 )
insert into externalcandidate values('000002','Barbara','Johnson','227 Beach Ave.','Alexandria ','Virginia','22304-3700','001','(703)123-5673 ','0005','08/14/2001',null,null,'0001',null,null,null,null ,'BBA',3 ,'1/15/1965','F','0003', 40000.00,null,'barba@speedmail.com','P','08/21/97',82,'08/28/97','000001','Good Communication skill',9)
insert into externalcandidate values('000003','Betty','Williams','1 Tread Road','Dublin ','Georgia','43017-3004','001','(614)458-3299 ','0010','05/02/2000',null,null,'0001',null,null,null,null ,'Graduate',2 ,'8/6/1971','F','0007', 30000.00,null,'bettyw@dpeedmil.cm','P','05/09/98',70,'05/20/98','000001','Good presentation skill',8 )
insert into externalcandidate values('000004','Carol','Jones','765 Furling Rd Apt','Norton ','Kansas','67654-1255','001','(785)678-4544 ','0012','05/02/2000',null,null,null,'0001',null,null,null ,'Graduate',4 ,'06/10/1979 ','F','0005', 0.00,null,NULL,'P','05/09/98',45,'05/24/98','000001','Quick Learner',6 )
insert into externalcandidate values('000005','Catherine','Roberts','5508 Aquiline Court','Norton ','Kansas','67654-1255','001','(785)445-2256 ','0007','05/05/2000','000001',null,null,null,null,null,null ,'BBA',5 ,'10/10/1962','F','0001', 0.00,null,NULL,'P','05/09/98',74,'05/28/98','000001','Good at planning',7 )
insert into externalcandidate values('000010','David','Moore','8808 Joviality Drive','Houston ','Texas','77063-5564','001','(281)982-5577 ','0001','08/07/2000','000002',null,null,null,null,null,null ,'Graduate',1 ,'11/23/1967','M','0003', 25000.00,null,'davidm@qmail.com','P','08/14/98',92,'08/21/98','000006','Takes lots of Initiative',9 )
insert into externalcandidate values('000011','Deborah','Taylor','2199- Fairfax Drive ','Seattle ','Washington','98122-2514','001','(206)889-2235 ','0007','08/07/2000',null,null,null,null,'0001',null,null,'BBA',4 ,'10/14/1964','F','0004', 31000.00,null,'deboraht@qmail.com','P','08/14/98',88,'08/21/98','000006','Has worked as good team member',8 )
insert into externalcandidate values('000012','Donna','Anderson','7930 Orange St. ','Mentor ','Ohio','44060-4514','001','(440)845-2323 ','0010','08/07/2001',null,'0003',null,null,null,null,null ,'MBA',4,'7/18/1971','F','0012', 0.00,null,'Donnaa@speedmail.com','P','08/14/98',83,'08/21/98','0000011','Hard working',8 )
insert into externalcandidate values('000014','Elizabeth','Jackson','598 Apex Avenue #2','Dublin ','Georgia','43017-3004','001','(614)545-9078 ','0013','09/07/2000',null,null,null,null,'0002',null,null ,'Graduate',4 ,'10/12/1969','F','0002', 28000.00,null,'elizabethj@qmail.com','P','09/13/2000',65,'09/21/2000','000001','Good presentation skills',6 )
insert into externalcandidate values('000016','Helen','White','Fleet Street','New York City ','New York','10024-7401','001','(212)585-7796 ','0015','12/10/2000',null,null,null,null,null,null,null ,'Graduate',4 ,'2/1/1972 ','F','0001', 40000.00,null,'helenw@spedmail.com','P','12/15/2000',94,'12/20/2000','000006','Quick Learner',9 )
insert into externalcandidate values('000018','Jennifer','Martin','9812 76th Street ','Abilene ','Texas','79603-2485','001','(915)569-7789 ','0015','12/16/2000',null,null,null,'0006',null,'0001',null ,'BBA',4 ,'5/22/1966','F','0004', 26000.00,null,'jenniferm@qmail.com','P','12/20/2000',97,'12/23/2000','000006','Good at planning and good analytical skills',9 )
insert into externalcandidate values('000021','Joseph','Martinez','995 Rind Street ','San Diego ','California','92122-2017','001','(619)456-9032 ','0014','01/16/2001',null,'0005',null,null,null,null,null ,'Graduate',4 ,'4/13/1971','M','0005', 0.00,null,'josephm@qmail.com','P','01/22/2001',81,'01/26/2001','000006','Commited and Hard working',8 )
insert into externalcandidate values('000022','Joyce','Phillips','535 Darwin Avenue ','Columbus ','Georgia','31904-7624','001','(706)789-6905 ','0001','01/16/2001',null,null,'0002',null,null,null,null ,'BBA',4 ,'3/14/1966','M','0006', 0.00,null,'joycep@speedmail.com','P','01/22/2001',61,'01/26/2001','000001','Long term potential',6 )
insert into externalcandidate values('000026','Linda','Lewis','1524 Patagonia Lane ','Columbus ','Georgia','31904-7624','001','(706)459-4563 ','0014','01/16/2001',null,'0005',null,null,null,null,null ,'Graduate',4 ,'11/06/1969','F','0006', 31000.00,null,'lindal@qmail.com','P','01/22/2001',69,'01/26/2001','000006','Helpfull in nature',6 )
insert into externalcandidate values('000029','Maria','Hall','936 Midland Drive ','Columbus ','Georgia','31904-7624','001','(706)345-8764 ','0008','02/01/2001',null,null,null,'0004',null,null,null ,'MBA',4,'10/21/1968','F','0006', 35000.00,null,'Mariah@speedmail.com','P','02/07/2001',57,'02/09/2001','000011','Customer oriented',8 )
insert into externalcandidate values('000033','Nancy','King','429 Ash Birch Lane ','Middle Town ','New Jersy','07748-3224','001','(732)563-2298 ','0006','02/10/2001',null,'0005',null,null,null,null,null ,'Graduate',4,'5/6/1970','F','0011', 25000.00,null,'nancyk@qmail.com','P','03/07/2001',76,'03/06/2001','000001','Needs to improve in communication,but commited to the job',7 )
insert into externalcandidate values('000035','Paul','Lopez','13459 Campton Street','Spring Field ','Ohio','07081-1442','001','(973)912-7905 ','0006','02/14/2001',null,null,null,'0002',null,null,null ,'Graduate',4,'11/1/1968','M','0008', 28000.00,null,'paull@qmail.com','P','03/08/2001',96,'03/14/2001','000001','Hard working but needs to improve in communication skill',9 )
insert into externalcandidate values('000038','Ruth','Green','459 Ridge Road ','Middle Town ','New Jersy','07748-3224','001','(732)347-9082 ','0003','03/01/2001',null,null,null,null,'0001',null,null ,'MBA',4 ,'12/02/1968','M','0006', 21000.00,null,'ruthg@speedmail.com','P','03/08/2001',88,'03/010/2001','000011','Helpfull in nature',8 )
insert into externalcandidate values('000039','Sandra','Adams','12454 Boggy Blvd. ','Middle Town ','New Jersy','07748-3224','001','(732)982-9503 ','0003','02/12/2001',null,null,'0002',null,null,null,null ,'Graduate',4,'05/22/1969','F','0004', 32000.00,null,'Sandra@qmail.com','P','02/14/2001',55,'02/20/2001','000001','Long term potential',6 )
insert into externalcandidate values('000040','Sarah','Baker','2394 Emerald Street ','Middle Town ','New Jersy','07748-3224','001','(732)439-2309 ','0002','02/12/2001',null,null,null,'0004',null,null,null ,'BBA',4 ,'11/17/1971','F','0004', 28000.00,null,'sarahb@qmail.com','P','02/15/2001',67,'02/21/2001','000011','Needs to improve in communication skills',6 )
insert into externalcandidate values('000045','William','Perez','987 Tetragon Avenue ','Las Vegas ','Nevada','89123-2514','001','(702)234-8764 ','0002','03/02/2001',null,'0004',null,null,null,null,null ,'Graduate',4 ,'2/7/1969','M','0005', 26000.00,null,'williamp@qmail.com','P','03/30/2001',78,'04/14/2001','000006','Customer oriented',8 )
insert into externalcandidate values('000046','David','Cooper','5614 Raffle Court ','Las Vegas ','Nevada','89123-2514','001','(702)678-3458 ','0003','03/06/2001',null,'0004',null,null,null,null,null ,'MBA',4 ,'04/08/1966','M','0005', 0.00,null,'davidc@speedmail.com','P','03/30/2001',89,'04/07/2001','000006','Long term potential, commited and hardworking',9 )
insert into externalcandidate values('000047','Peter','Prescott','340 Miasma Drive','Mentor ','Ohio','44060-4514','001','(440)890-4084 ','0015','03/10/2001',null,'0002',null,null,null,null,null ,'Graduate',4,'08/07/1971','M','0006', 29000.00,null,NULL,'P','03/30/2001',55,NULL,null,null,5 )
insert into externalcandidate values('000049','Jane','Schaffer','521 State Street','Mentor ','Ohio','44060-4514','001','(440)280-9999 ','0002','05/04/2001',null,null,null,'0003',null,null,null ,'Graduate',4,'9/15/1971','F','0004', 32000.00,null,NULL,'P','05/16/2001',84,NULL,null,null,8 )
go
raiserror('插入数据到 Skill 表....',0,1)
Insert into skill values('0001','Communication skill')
Insert into skill values('0002','Visual basic')
Insert into skill values('0003','Database Administration')
Insert into skill values('0005','Data Entry')
Insert into skill values('0006','Team leading')
Insert into skill values('0007','Power Builder')
Insert into skill values('0008','Record Keeping')
Insert into skill values('0009','Presentation Skill')
Insert into skill values('0010','Convincing')
Insert into skill values('0011','Learning')
Insert into skill values('0012','Planning')
Insert into skill values('0013','Project Management')
Insert into skill values('0014','Time Keeping')
Insert into skill values('0015','Analytical')
Insert into skill values('0016','MS-Ofice')
Insert into skill values('0017','Initiative')
Insert into skill values('0018','Self Motivation')
Insert into skill values('0019','Scheduling')
Insert into skill values('0020','Interpersonal Skill')
Insert into skill values('0021','Scheduling')
go
raiserror('插入数据到 Employee 表....',0,1)
Insert into employee values('000001','Angela','Smith','000001','16223 Radiance Court','Kansas City ','Kansas','66101-2945','001','(913)227-2344 ','Graduate','02/12/1969','F','0001','Senior Manager','angelas@qmail.com','0002','Kansas City ',null,'06/16/2001',null,'627-89-6952',null)
Insert into employee values('000002','Betty','Williams','000003','1 Tread Road','Dublin ','California','43017-3004','001','(614)458-3299 ','Graduate','08/06/1971','F','0010','Assistant secretary','bettyw@dpeedmil.cm','0005','Dublin ',null,'06/16/2000',null,'617-40-3628',null)
Insert into employee values('000003','Carol','Jones','000004','765 Furling Rd Apt','Norton ','Kansas','67654-1255','001','(785)678-4544 ','Graduate','06/10/1979','F','0012','Senior Receptionist','carolj@qmail.com','0003','Norton ',null,'06/19/2000',null,'806-84-8173',null)
Insert into employee values('000004','Catherine','Roberts','000005','5508 Aquiline Court','Norton ','kansas','67654-1255','001','(785)445-2256 ','BBA','10/10/1962','F','0007','Junior manager','catheriner@qmail.com','0009','Norton ',null,'06/29/2000',null,'763-26-5478',null)
Insert into employee values('000005','David','Moore','000010','8808 Joviality Drive','Houston ','Texas','77063-5564','001','(281)982-5577','Graduate','11/23/1967','M','0001','Junior manager','davidm@qmail.com','0002','Houston',null,'06/29/2000',null,'732-43-5067',null)
Insert into employee values('000006','Elizabeth','Jackson','000014','598 Apex Avenue #2','Dublin ','Georgia','43017-3004','001','(614)545-9078 ','Graduate','10/12/1969','F','0013','Assistant consultant','elizabethj@qmail.com','0007','Dublin ',null,'07/21/2000',null,'356-05-5459',null)
Insert into employee values('000007','Helen','White','000016','Fleet Street','New York City ','New York','10024-7401','001','(212)585-7796 ','Graduate','02/01/1972','F','0015','Junior Receptionist','helenw@spedmail.com','0003','New York City ',null,'08/29/2000',null,'326-69-3560',null)
Insert into employee values('000008','Jennifer','Martin','000018','9812 76th Street','Dublin','California','49603-2485','001','(617)569-7789 ','BBA','05/22/1966','F','0015','Junior Receptionist','jenniferm@qmail.com','0004','Dublin ',null,'08/30/2000',null,'343-26-6693',null)
Insert into employee values('000009','Linda','Lewis','000026','1524 Patagonia Lane ','Columbus ','Georgia','31904-7624','001','(706)459-4563 ','Graduate','11/06/1969','F','0014','Assistant Technician','lindal@qmail.com','0010','Columbus ',null,'09/08/2000',null,'384-08-6778',null)
Insert into employee values('000010','Maria','Hall','000029','936 Midland Drive ','Columbus ','Georgia','31904-7624','001','(706)345-8764 ','MBA','10/21/1968','F','0008','Junior operator','Mariah@speedmail.com','0003','Columbus ',null,'09/08/2000',null,'783-06-7914',null)
Insert into employee values('000011','Paul','Lopez','000035','13459 Campton Street','Spring Field ','Ohio','07081-1442','001','(973)912-7905 ','Graduate','11/01/1968','M','0006','Assistant Manager','paull@qmail.com','0009','Spring Field ',null,'09/21/2000',null,'990-35-4788',null)
Insert into employee values('000012','Sandra','Adams','000039','12454 Boggy Blvd. ','Middle Town ','New Jersy','07748-3224','001','(732)982-9503 ','Graduate','05/22/1969','F','0003','Senior Analyst','Sandra@qmail.com','0009','Middle Town ',null,'09/26/2000',null,'499-03-5817',null)
Insert into employee values('000013','William','Perez','000045','987 Tetragon Avenue ','Las Vegas ','Nevada','89123-2514','001','(702)234-8764 ','Graduate','02/07/1969','M','0002','Junior Manager','williamp@qmail.com','0003','Las Vegas ',null,'10/05/2000',null,'517-82-4993',null)
Insert into employee values('000014','David','Cooper','000046','5614 Raffle Court ','Las Vegas ','Nevada','89123-2514','001','(702)678-3458 ','MBA','04/08/1966','M','0003','Junior analyst','davidc@speedmail.com','0009','Las Vegas ',null,'10/05/2000',null,'499-03-5816',null)
Insert into employee values('000015','Peter','Prescott','000047','340 Miasma Drive','Mentor ','Ohio','44060-4514','001','(440)890-4084 ','Graduate','08/07/1971','M','0015','Junior Receptionist','peterp@qmail.com','0008','Mentor ',null,'11/08/2000',null,'216-22-6414',null)
go
raiserror('插入数据到 AnnualSalary 表....',0,1)
insert into annualsalary values('000001',48000 ,2000)
insert into annualsalary values('000002',36000 ,2000)
insert into annualsalary values('000003',30000 ,2000)
insert into annualsalary values('000004',48000 ,2000)
insert into annualsalary values('000005',48000 ,2000)
insert into annualsalary values('000006',48000 ,2000)
insert into annualsalary values('000007',24000 ,2000)
insert into annualsalary values('000008',24000 ,2000)
insert into annualsalary values('000009',30000 ,2000)
insert into annualsalary values('000010',24000 ,2000)
insert into annualsalary values('000011',24000 ,2000)
insert into annualsalary values('000012',36000 ,2000)
insert into annualsalary values('000013',48000 ,2000)
insert into annualsalary values('000014',36000 ,2000)
insert into annualsalary values('000015',24000 ,2000)
insert into annualsalary values('000001',48000 ,2001)
insert into annualsalary values('000002',36000 ,2001)
insert into annualsalary values('000003',30000 ,2001)
insert into annualsalary values('000004',48000 ,2001)
insert into annualsalary values('000005',48000 ,2001)
insert into annualsalary values('000006',48000 ,2001)
insert into annualsalary values('000007',24000 ,2001)
insert into annualsalary values('000008',24000 ,2001)
insert into annualsalary values('000009',30000 ,2001)
insert into annualsalary values('000010',24000 ,2001)
insert into annualsalary values('000011',24000 ,2001)
insert into annualsalary values('000012',36000 ,2001)
insert into annualsalary values('000013',48000 ,2001)
insert into annualsalary values('000014',36000 ,2001)
insert into annualsalary values('000015',24000 ,2001)
go
raiserror('插入数据到 MonthlySalary 表....',0,1)
insert into monthlysalary values('000001', 3833.33,'07/01/1999',0)
insert into monthlysalary values('000001', 3833.33,'08/01/1999',0)
insert into monthlysalary values('000001', 3833.33,'09/01/1999',0)
insert into monthlysalary values('000001', 3833.33,'10/01/1999',0)
insert into monthlysalary values('000001', 3833.33,'11/01/1999',0)
insert into monthlysalary values('000001', 3833.33,'12/01/1999',0)
--------------------------------------------------------------------
insert into monthlysalary values('000001', 4000.00,'01/01/2000',0)
insert into monthlysalary values('000001', 4000.00,'02/01/2000',0)
insert into monthlysalary values('000001', 4000.00,'03/01/2000',0)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -