테이블을 전부 지우는 경우..

DROP TABLE customer.customer;

테이블을 다시 만듭니다.  mssql에서는 identity(1,1)

create table Customer.Customer
( 
   Id int AUTO_INCREMENT PRIMARY KEY,
   FirstName varchar(50),
   LastName varchar(50),
   Age int,
   City varchar(50)
);

새로 Custom 데이타도 입력하고

insert into customer.customer (FirstName, LastName, Age, City) values  ('Joey', 'Blue', 40, 'Goddard');
insert into customer.customer (FirstName, LastName, Age, City) values  ('Barry', 'Bonds', 50, 'San Francisco');
insert into customer.customer (FirstName, LastName, Age, City) values  ('Mike', 'Schmidt', 60, 'KC');

Product 데이타도 입력하고

create table Customer.Products
( 
   Id int AUTO_INCREMENT PRIMARY KEY,
   ProductName varchar(50)
);

alter table Customer.Products
add Price float;

insert into Customer.Products (ProductName, Price) values ('Baseball', 5.95);
insert into Customer.Products (ProductName, Price) values ('Bat', 195.99);

select * from Customer.Products;

Order 데이타도 만들고

create table Customer.Orders
(
    OrderID int auto_increment primary Key,
    OrderDate Datetime,
    CustomerID int,
    ProductID int
);

select * from customer.orders;
select * from customer.Products;
select * from customer.Customer;

지금 (GetDate대신에 now로.) Barry Bonds가 Bat를 샀다고 하면

insert into customer.Orders (OrderDate, CustomerID, ProductID) values (now(), 2, 2);