auditapp.txt

本人使用SQL SERVER 数据库3年

/* AuditApp.txt */

USE LumigentDemoDB

SETUSER

SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(23,'Jordan','Michael','44 State Street','Chicago','IL','60015','USA')

SETUSER
Setuser 'Sales'
INSERT Service (ServID, CustID, EmpID, ServName, ServDate, ServPrice) VALUES (4,23,2,'BasicMonthly','20011215',14.95)
SETUSER

SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(100,'Washington','George','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(101,'Adams','John','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'PriceReview'
UPDATE Service SET ServDate = '20011231', ServPrice = 29.95 WHERE CustID = 23

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(102,'Jefferson','Thomas','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(103,'Madison','James','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(104,'Monroe','James','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'CustomerService'
UPDATE Service SET ServDate = '20020111', ServPrice = 14.95, EmpID = 1 WHERE CustID = 23

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(105,'Adams','John Quincy','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(106,'Jackson','Andrew','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(107,'Buren','Martin Van','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'PriceReview'
UPDATE Service SET ServDate = '20020131', ServPrice = 29.95 WHERE CustID = 23

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(108,'Henry','William','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(109,'Tyler','John','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(110,'Polk','James Knox','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(111,'Taylor','Zachary','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'CustomerService'
UPDATE Service SET ServDate = '20020218', ServPrice = 14.95, EmpID = 1 WHERE CustID = 23

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(112,'Fillmore','Millard','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(113,'Pierce','Franklin','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(114,'Buchanan','James','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'PriceReview'
UPDATE Service SET ServDate = '20020228', ServPrice = 29.95 WHERE CustID = 23

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(115,'Lincoln','Abraham','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(116,'Johnson','Andrew','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(117,'Grant','Ulysses S.','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(118,'Hayes','Rutherford B.','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'CustomerService'
UPDATE Service SET ServDate = '20020315', ServPrice = 14.95, EmpID = 1 WHERE CustID = 23

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(119,'Arthur','Chester A.','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(120,'Cleveland','Grover','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(121,'Harrison','Benjamin','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(122,'McKinley','William','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(123,'Roosevelt','Theodore','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'PriceReview'
UPDATE Service SET ServDate = '20020331', ServPrice = 29.95 WHERE CustID = 23

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(124,'Taft','William Howard','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(125,'Wilson','Woodrow','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(126,'Harding','Warren G.','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(127,'Coolidge','Calvin','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(128,'Hoover','Herbert','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'CustomerService'
UPDATE Service SET ServDate = '20020407', ServPrice = 14.95, EmpID = 1 WHERE CustID = 23

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(129,'Roosevelt','Franklin Delano','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(130,'Truman','Harry S.','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(131,'Eisenhower','Dwight D.','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(132,'Kennedy','John F.','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'PriceReview'
UPDATE Service SET ServDate = '20020430', ServPrice = 29.95 WHERE CustID = 23

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(133,'Johnson','Lyndon B.','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(134,'Nixon','Richard M.','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(135,'Ford','Gerald R.','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(136,'Carter','Jimmy','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(137,'Reagan','Ronald','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(138,'Bush','George','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(139,'Clinton','Bill','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER
SETUSER 'Sales'
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(140,'Bush','George W.','1600 Pennsylvania Avenue','Washington','DC','20500','USA')

SETUSER