populatetable.txt

来自「本人使用SQL SERVER 数据库3年」· 文本 代码 · 共 15 行

/* PopulateTable.txt */

USE LumigentDemoDB

INSERT Employees (EmpID,Last,First,PayRate) VALUES(1,'Newman','Alfred E.',10.50)
INSERT Employees (EmpID,Last,First,PayRate) VALUES(2,'Mouse','Mick E.',9.00)

INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(1,'Santana','Carlos','1151 Malibu Canyon Road','Malibu','CA','77711','USA')
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(2,'Garcia','Jerry','714 Haight Street','San Francisco','CA','70707','USA')
INSERT Customers (CustID,Last,First,Address,City,Region,PostalCode,Country) VALUES(3,'Young','Neil','130 King Street West','Toronto','Ontario','M5X 1A9','CANADA')

INSERT Service (ServID, CustID, EmpID, ServName, ServDate, ServPrice) VALUES (1,1,2,'BasicMonthly','20011214',19.95)
INSERT Service (ServID, CustID, EmpID, ServName, ServDate, ServPrice) VALUES (2,2,2,'BasicMonthly','20011215',21.95)
INSERT Service (ServID, CustID, EmpID, ServName, ServDate, ServPrice) VALUES (3,3,1,'DSL','20011217',59.95)