Slide 179
Slide 179 text
CREATE TABLE Orders!
(!
O_ID int AUTO_INCREMENT,!
C_ID int,!
O_QTY int,!
DATE datetime NOT NULL!
!
PRIMARY KEY (OrderID),!
FOREIGN KEY (CustomerID) REFERENCES Customers(C_ID),!
CONSTRAINT [O_QTY > 0]!
)
CREATE PROCEDURE CreateOrder(@C_ID int, @O_QTY int)!
AS!
INSERT INTO Orders (C_ID, O_QTY, DATE) VALUES!
(C_ID, O_QTY, NOW());!
GO
Standard SQL with
extensions and !
analysis!