customer.sql

来自「《SQLServer2000宝典》—包括本书中的所有代码」· SQL 代码 · 共 8 行

use cha2warehouse
Insert into Customer(CustomerID,CustomerName) Values(1,'Betty Smith')
Insert into Customer(CustomerID,CustomerName) Values(2,'John Doe')
Insert into Customer(CustomerID,CustomerName) Values(3,'Jenny Johnson')
Insert into Customer(CustomerID,CustomerName) Values(4,'Stephie Stevens')
Insert into Customer(CustomerID,CustomerName) Values(5,'Dave Jones')
Insert into Customer(CustomerID,CustomerName) Values(6,'John Strycker')
Insert into Customer(CustomerID,CustomerName) Values(7,'Robin Johansen')