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 AND Type 'Original' AND QuantityOnHand OR Type 'Limited Edition Print'
Record Count:
CREATE TABLE Artwork ArtworkID INT PRIMARY KEY, ArtistID INT NOT NULL, Title VARCHAR NOT NULL, Type VARCHAR NOT NULL, Price DECIMAL NOT NULL, QuantityOnHand INT NOT NULL CHECK QuantityOnHand AND Type 'Original' AND QuantityOnHand OR Type 'Limited Edition Print' CONSTRAINT FKArtistID FOREIGN KEY ArtistID REFERENCES ArtistsArtistID
Error ERROR MicrosoftODBC SQL Server DriverSQL ServerIncorrect syntax near
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
