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