Monday, October 15, 2018

bit of SQL

Create Table Sale
(
  SaleID int identity(1,1) primary key,
  SaleDate DateTime default Current_timestamp,
  CustomerID int Foreign Key 
            references Customer(CustomerID)
);

Insert into Product(ProductName, ProductPrice)
Values('Plain donut',1.50),
('Cheese Danish', 3.25)

Select * from Product

No comments:

Post a Comment