Question: QuantityOnHand INT NOT NULL CHECK ( QuantityOnHand > = 1 AND ( Type = 'Original' AND QuantityOnHand = 1 OR Type = 'Limited Edition Print'

QuantityOnHand INT NOT NULL CHECK (QuantityOnHand >=1 AND (Type = 'Original' AND QuantityOnHand =1 OR Type = 'Limited Edition Print')),
Record Count: 0
CREATE TABLE Artwork ( ArtworkID INT PRIMARY KEY, ArtistID INT NOT NULL, Title VARCHAR(100) NOT NULL, Type VARCHAR(15) NOT NULL, Price DECIMAL NOT NULL, QuantityOnHand INT NOT NULL CHECK (QuantityOnHand >=1 AND (Type = 'Original' AND QuantityOnHand =1 OR Type = 'Limited Edition Print')), CONSTRAINT FK_ArtistID FOREIGN KEY (ArtistID) REFERENCES Artists(ArtistID),))
Error ERROR [42000][Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!