installunipubs2

sybase数据库ct library的开发,使用了所以有函数

insert roysched
values('BU1111', 12001, 16000, 16)
go
insert roysched
values('BU1111', 16001, 20000, 18)
go
insert roysched
values('BU1111', 20001, 24000, 20)
go
insert roysched
values('BU1111', 24001, 28000, 22)
go
insert roysched
values('BU1111', 28001, 50000, 24)
go
insert roysched
values('MC2222', 0, 2000, 10)
go
insert roysched
values('MC2222', 2001, 4000, 12)
go
insert roysched
values('MC2222', 4001, 8000, 14)
go
insert roysched
values('MC2222', 8001, 12000, 16)
go
insert roysched
values('MC2222', 8001, 12000, 16)
go
insert roysched
values('MC2222', 12001, 20000, 18)
go
insert roysched
values('MC2222', 20001, 50000, 20)
go
insert roysched
values('TC7777', 0, 5000, 10)
go
insert roysched
values('TC7777', 5001, 15000, 12)
go
insert roysched
values('TC7777', 15001, 50000, 14)
go
insert roysched
values('TC4203', 0, 2000, 10)
go
insert roysched
values('TC4203', 2001, 8000, 12)
go
insert roysched
values('TC4203', 8001, 16000, 14)
go
insert roysched
values('TC4203', 16001, 24000, 16)
go
insert roysched
values('TC4203', 24001, 32000, 18)
go
insert roysched
values('TC4203', 32001, 40000, 20)
go
insert roysched
values('TC4203', 40001, 50000, 22)
go
insert roysched
values('BU7832', 0, 5000, 10)
go
insert roysched
values('BU7832', 5001, 10000, 12)
go
insert roysched
values('BU7832', 10001, 15000, 14)
go
insert roysched
values('BU7832', 15001, 20000, 16)
go
insert roysched
values('BU7832', 20001, 25000, 18)
go
insert roysched
values('BU7832', 25001, 30000, 20)
go
insert roysched
values('BU7832', 30001, 35000, 22)
go
insert roysched
values('BU7832', 35001, 50000, 24)
go
insert roysched
values('PS1372', 0, 10000, 10)
go
insert roysched
values('PS1372', 10001, 20000, 12)
go
insert roysched
values('PS1372', 20001, 30000, 14)
go
insert roysched
values('PS1372', 30001, 40000, 16)
go
insert roysched
values('PS1372', 40001, 50000, 18)
go
dump transaction unipubs2 with truncate_only
go
insert sales values ('7066', 'BA27618', '10/12/85')
go
insert sales values ('5023', 'AB-123-DEF-425-1Z3', '10/31/85')
go
insert sales values ('5023', 'AB-872-DEF-732-2Z1', '11/06/85')
go
insert sales values ('8042', '12-F-9', '07/13/86')
go
insert sales values ('7896', '124152', '08/14/86')
go
insert sales values ('7131', 'Asoap132', '11/16/86')
go
insert sales values ('5023', 'BS-345-DSE-860-1F2', '12/12/86')
go
insert sales values ('7067', 'NB-1.142', '01/02/87')
go
insert sales values ('5023', 'AX-532-FED-452-2Z7', '12/01/90')
go
insert sales values ('5023', 'NF-123-ADS-642-9G3', '07/18/87')
go
insert sales values ('7131', 'Fsoap867', '09/08/87')
go
insert sales values ('7066', 'BA52498', '10/27/87')
go
insert sales values ('8042', '91-A-7', '03/20/91')
go
insert sales values ('8042', '91-V-7', '03/20/91')
go
insert sales values ('8042', '55-V-7', '03/20/91')
go
insert sales values ('8042', '13-J-9', '01/13/88')
go
insert sales values ('7896', '234518', '02/14/91')
go
insert sales values ('5023', 'GH-542-NAD-713-9F9', '03/15/87')
go
insert sales values ('7131', 'Asoap432', '12/20/90')
go
insert sales values ('5023', 'ZA-000-ASD-324-4D1', '07/27/88')
go
insert sales values ('7066', 'BA71224', '08/05/88')
go
insert sales values ('5023', 'ZD-123-DFG-752-9G8', '03/21/91')
go
insert sales values ('8042', '13-E-7', '05/23/89')
go
insert sales values ('7067', 'NB-3.142', '06/13/90')
go
insert sales values ('5023', 'ZS-645-CAT-415-1B2', '03/21/91')
go
insert sales values ('5023', 'XS-135-DER-432-8J2', '03/21/91')
go
insert sales values ('5023', 'ZZ-999-ZZZ-999-0A0', '03/21/91')
go
insert sales values ('6380', '342157', '12/13/85')
go
insert sales values ('6380', '356921', '02/17/91')
go
insert sales values ('6380', '234518', '09/30/87')
go
insert salesdetail values ('7896', '234518', 'TC3218', 75, 40)
go
insert salesdetail values ('7896', '234518', 'TC7777', 75, 40)
go
insert salesdetail values ('7131', 'Asoap432', 'TC3218', 50, 40)
go
insert salesdetail values ('7131', 'Asoap432', 'TC7777', 80, 40)
go
insert salesdetail values ('5023', 'XS-135-DER-432-8J2', 'TC3218', 85, 40)
go
insert salesdetail values ('8042', '91-A-7', 'PS3333', 90, 45)
go
insert salesdetail values ('8042', '91-A-7', 'TC3218', 40, 45)
go
insert salesdetail values ('8042', '91-A-7', 'PS2106', 30, 45)
go
insert salesdetail values ('8042', '91-V-7', 'PS2106', 50, 45)
go
insert salesdetail values ('8042', '55-V-7', 'PS2106', 31, 45)
go
insert salesdetail values ('8042', '91-A-7', 'MC3021', 69, 45)
go
insert salesdetail values ('5023', 'BS-345-DSE-860-1F2', 'PC1035', 1000, 46.7)
go
insert salesdetail values ('5023', 'AX-532-FED-452-2Z7', 'BU2075', 500, 46.7)
go
insert salesdetail values ('5023', 'AX-532-FED-452-2Z7', 'BU1032', 200, 46.7)
go
insert salesdetail values ('5023', 'AX-532-FED-452-2Z7', 'BU7832', 150, 46.7)
go
insert salesdetail values ('5023', 'AX-532-FED-452-2Z7', 'PS7777', 125, 46.7)
go
insert salesdetail values ('5023', 'NF-123-ADS-642-9G3', 'TC7777', 1000, 46.7)
go
insert salesdetail values ('5023', 'NF-123-ADS-642-9G3', 'BU1032', 1000, 46.7)
go
insert salesdetail values ('5023', 'NF-123-ADS-642-9G3', 'PC1035', 750, 46.7)
go
insert salesdetail values ('7131', 'Fsoap867', 'BU1032', 200, 46.7)
go
insert salesdetail values ('7066', 'BA52498', 'BU7832', 100, 46.7)
go
insert salesdetail values ('7066', 'BA71224', 'PS7777', 200, 46.7)
go
insert salesdetail values ('7066', 'BA71224', 'PC1035', 300, 46.7)
go
insert salesdetail values ('7066', 'BA71224', 'TC7777', 350, 46.7)
go
insert salesdetail values ('5023', 'ZD-123-DFG-752-9G8', 'PS2091', 1000, 46.7)
go
insert salesdetail values ('7067', 'NB-3.142', 'PS2091', 200, 46.7)
go
insert salesdetail values ('7067', 'NB-3.142', 'PS7777', 250, 46.7)
go
insert salesdetail values ('7067', 'NB-3.142', 'PS3333', 345, 46.7)
go
insert salesdetail values ('7067', 'NB-3.142', 'BU7832', 360, 46.7)
go
insert salesdetail values ('5023', 'XS-135-DER-432-8J2', 'PS2091', 845, 46.7)
go
insert salesdetail values ('5023', 'XS-135-DER-432-8J2', 'PS7777', 581, 46.7)
go
insert salesdetail values ('5023', 'ZZ-999-ZZZ-999-0A0', 'PS1372', 375, 46.7)
go
insert salesdetail values ('7067', 'NB-3.142', 'BU1111', 175, 46.7)
go
insert salesdetail values ('5023', 'XS-135-DER-432-8J2', 'BU7832', 885, 46.7)
go
insert salesdetail values ('5023', 'ZD-123-DFG-752-9G8', 'BU7832', 900, 46.7)
go
insert salesdetail values ('5023', 'AX-532-FED-452-2Z7', 'TC4203', 550, 46.7)
go
insert salesdetail values ('7131', 'Fsoap867', 'TC4203', 350, 46.7)
go
insert salesdetail values ('7896', '234518', 'TC4203', 275, 46.7)
go
insert salesdetail values ('7066', 'BA71224', 'TC4203', 500, 46.7)
go
insert salesdetail values ('7067', 'NB-3.142', 'TC4203', 512, 46.7)
go
insert salesdetail values ('7131', 'Fsoap867', 'MC3021', 400, 46.7)
go
insert salesdetail values ('5023', 'AX-532-FED-452-2Z7', 'PC8888', 105, 46.7)
go
insert salesdetail values ('5023', 'NF-123-ADS-642-9G3', 'PC8888', 300, 46.7)
go
insert salesdetail values ('7066', 'BA71224', 'PC8888', 350, 46.7)
go
insert salesdetail values ('7067', 'NB-3.142', 'PC8888', 335, 46.7)
go
insert salesdetail values ('7131', 'Asoap432', 'BU1111', 500, 46.7)
go
insert salesdetail values ('7896', '234518', 'BU1111', 340, 46.7)
go
insert salesdetail values ('5023', 'AX-532-FED-452-2Z7', 'BU1111', 370, 46.7)
go
insert salesdetail values ('5023', 'ZD-123-DFG-752-9G8', 'PS3333', 750, 46.7)
go
insert salesdetail values ('8042', '13-J-9', 'BU7832', 300, 51.7)
go
insert salesdetail values ('8042', '13-E-7', 'BU2075', 150, 51.7)
go
insert salesdetail values ('8042', '13-E-7', 'BU1032', 300, 51.7)
go
insert salesdetail values ('8042', '13-E-7', 'PC1035', 400, 51.7)
go
insert salesdetail values ('8042', '91-A-7', 'PS7777', 180, 51.7)
go
insert salesdetail values ('8042', '13-J-9', 'TC4203', 250, 51.7)
go
insert salesdetail values ('8042', '13-E-7', 'TC4203', 226, 51.7)
go
insert salesdetail values ('8042', '13-E-7', 'MC3021', 400, 51.7)
go
insert salesdetail values ('8042', '91-V-7', 'BU1111', 390, 51.7)
go
insert salesdetail values ('5023', 'AB-872-DEF-732-2Z1', 'MC3021', 5000, 50)
go
insert salesdetail values ('5023', 'NF-123-ADS-642-9G3', 'PC8888', 2000, 50)
go
insert salesdetail values ('5023', 'NF-123-ADS-642-9G3', 'BU2075', 2000, 50)
go
insert salesdetail values ('5023', 'GH-542-NAD-713-9F9', 'PC1035', 2000, 50)
go
insert salesdetail values ('5023', 'ZA-000-ASD-324-4D1', 'PC1035', 2000, 50)
go
insert salesdetail values ('5023', 'ZA-000-ASD-324-4D1', 'PS7777', 1500, 50)
go
insert salesdetail values ('5023', 'ZD-123-DFG-752-9G8', 'BU2075', 3000, 50)
go
insert salesdetail values ('5023', 'ZD-123-DFG-752-9G8', 'TC7777', 1500, 50)
go
insert salesdetail values ('5023', 'ZS-645-CAT-415-1B2', 'BU2075', 3000, 50)
go
insert salesdetail values ('5023', 'ZS-645-CAT-415-1B2', 'BU2075', 3000, 50)
go
insert salesdetail values ('5023', 'XS-135-DER-432-8J2', 'PS3333', 2687, 50)
go
insert salesdetail values ('5023', 'XS-135-DER-432-8J2', 'TC7777', 1090, 50)
go
insert salesdetail values ('5023', 'XS-135-DER-432-8J2', 'PC1035', 2138, 50)
go
insert salesdetail values ('5023', 'ZZ-999-ZZZ-999-0A0', 'MC2222', 2032, 50)
go
insert salesdetail values ('5023', 'ZZ-999-ZZZ-999-0A0', 'BU1111', 1001, 50)
go
insert salesdetail values ('5023', 'ZA-000-ASD-324-4D1', 'BU1111', 1100, 50)
go
insert salesdetail values ('5023', 'NF-123-ADS-642-9G3', 'BU7832', 1400, 50)
go
insert salesdetail values ('5023', 'BS-345-DSE-860-1F2', 'TC4203', 2700, 50)
go
insert salesdetail values ('5023', 'GH-542-NAD-713-9F9', 'TC4203', 2500, 50)
go
insert salesdetail values ('5023', 'NF-123-ADS-642-9G3', 'TC4203', 3500, 50)
go
insert salesdetail values ('5023', 'BS-345-DSE-860-1F2', 'MC3021', 4500, 50)
go
insert salesdetail values ('5023', 'AX-532-FED-452-2Z7', 'MC3021', 1600, 50)
go
insert salesdetail values ('5023', 'NF-123-ADS-642-9G3', 'MC3021', 2550, 50)
go
insert salesdetail values ('5023', 'ZA-000-ASD-324-4D1', 'MC3021', 3000, 50)
go
insert salesdetail values ('5023', 'ZS-645-CAT-415-1B2', 'MC3021', 3200, 50)
go
insert salesdetail values ('5023', 'BS-345-DSE-860-1F2', 'BU2075', 2200, 50)
go
insert salesdetail values ('5023', 'GH-542-NAD-713-9F9', 'BU1032', 1500, 50)
go
insert salesdetail values ('5023', 'ZZ-999-ZZZ-999-0A0', 'PC8888', 1005, 50)
go
insert salesdetail values ('7896', '124152', 'BU2075', 42, 50.5)
go
insert salesdetail values ('7896', '124152', 'PC1035', 25, 50.5)
go
insert salesdetail values ('7131', 'Asoap132', 'BU2075', 35, 50.5)
go
insert salesdetail values ('7067', 'NB-1.142', 'PC1035', 34, 50.5)
go
insert salesdetail values ('7067', 'NB-1.142', 'TC4203', 53, 50.5)
go
insert salesdetail values ('8042', '12-F-9', 'BU2075', 30, 55.5)
go
insert salesdetail values ('8042', '12-F-9', 'BU1032', 94, 55.5)
go
insert salesdetail values ('7066', 'BA27618', 'BU2075', 200, 57.2)
go
insert salesdetail values ('7896', '124152', 'TC4203', 350, 57.2)
go
insert salesdetail values ('7066', 'BA27618', 'TC4203', 230, 57.2)
go
insert salesdetail values ('7066', 'BA27618', 'MC3021', 200, 57.2)
go
insert salesdetail values ('7131', 'Asoap132', 'MC3021', 137, 57.2)
go
insert salesdetail values ('7067', 'NB-1.142', 'MC3021', 270, 57.2)
go
insert salesdetail values ('7067', 'NB-1.142', 'BU2075', 230, 57.2)
go
insert salesdetail values ('7131', 'Asoap132', 'BU1032', 345, 57.2)
go
insert salesdetail values ('7067', 'NB-1.142', 'BU1032', 136, 57.2)
go
insert salesdetail values ('8042', '12-F-9', 'TC4203', 300, 62.2)
go
insert salesdetail values ('8042', '12-F-9', 'MC3021', 270, 62.2)
go
insert salesdetail values ('8042', '12-F-9', 'PC1035', 133, 62.2)
go
insert salesdetail values ('5023', 'AB-123-DEF-425-1Z3', 'TC4203', 2500, 60.5)
go
insert salesdetail values ('5023', 'AB-123-DEF-425-1Z3', 'BU2075', 4000, 60.5)
go
insert salesdetail values ('6380', '342157', 'BU2075', 200, 57.2)
go
insert salesdetail values ('6380', '342157', 'MC3021', 250, 57.2)
go
insert salesdetail values ('6380', '356921', 'PS3333', 200, 46.7)
go
insert salesdetail values ('6380', '356921', 'PS7777', 500, 46.7)
go
insert salesdetail values ('6380', '356921', 'TC3218', 125, 46.7)
go
insert salesdetail values ('6380', '234518', 'BU2075', 135, 46.7)
go
insert salesdetail values ('6380', '234518', 'BU1032', 320, 46.7)
go
insert salesdetail values ('6380', '234518', 'TC4203', 300, 46.7)
go
insert salesdetail values ('6380', '234518', 'MC3021', 400, 46.7)
go
insert titleauthor
values('409-56-7008', 'BU1032', 1, 60)
go
insert titleauthor
values('486-29-1786', 'PS7777', 1, 100)
go
insert titleauthor
values('486-29-1786', 'PC9999', 1, 100)
go
insert titleauthor
values('712-45-1867', 'MC2222', 1, 100)
go
insert titleauthor
values('172-32-1176', 'PS3333', 1, 100)
go
insert titleauthor
values('213-46-8915', 'BU1032', 2, 40)
go
insert titleauthor
values('238-95-7766', 'PC1035', 1, 100)
go
insert titleauthor
values('213-46-8915', 'BU2075', 1, 100)
go
insert titleauthor
values('998-72-3567', 'PS2091', 1, 50)
go
insert titleauthor
values('899-46-2035', 'PS2091', 2, 50)
go
insert titleauthor
values('998-72-3567', 'PS2106', 1, 100)
go
insert titleauthor
values('722-51-5454', 'MC3021', 1, 75)
go
insert titleauthor
values('899-46-2035', 'MC3021', 2, 25)
go
insert titleauthor
values('807-91-6654', 'TC3218', 1, 100)
go
insert titleauthor
values('274-80-9391', 'BU7832', 1, 100)
go
insert titleauthor
values('427-17-2319', 'PC8888', 1, 50)
go
insert titleauthor
values('846-92-7186', 'PC8888', 2, 50)
go
insert titleauthor
values('756-30-7391', 'PS1372', 1, 75)
go
insert titleauthor
values('724-80-9391', 'PS1372', 2, 25)
go
insert titleauthor
values('724-80-9391', 'BU1111', 1, 60)
go
insert titleauthor
values('267-41-2394', 'BU1111', 2, 40)
go
insert titleauthor
values('672-71-3249', 'TC7777', 1, 40)
go
insert titleauthor
values('267-41-2394', 'TC7777', 2, 30)
go
insert titleauthor
values('472-27-2349', 'TC7777', 3, 30)
go
insert titleauthor
values('648-92-1872', 'TC4203', 1, 100)
go
insert titles
values ('PC8888', 'Secrets of Silicon Valley',
'popular_comp', '1389', $20.00, $8000.00, 4095,
"Muckraking reporting by two courageous women on the world's largest computer hardware and software manufacturers.",
'06/12/87', 1)
go
insert titles
values ('BU1032', "The Busy Executive's Database Guide",