中南大學(xué)數(shù)據(jù)庫實驗報告-文庫吧資料
2025-03-29 04:02本頁面
【正文】 GO14. SELECT cOrderNo ,dOrderDate FROM WHERE cOrderNo IN ( SELECT cOrderNo FROM WHERE cDeliveryStatus = 39。 OR cState = 39。三、實驗源代碼實驗一、3． /*sp_helpconstraint objname=Categorygo sp_helpconstraint objname=Countrygo sp_helpconstraint objname=OrderDetailgosp_helpconstraint objname=PickOfMonthgo sp_helpconstraint objname=Categorygo sp_helpconstraint objname=Recipientgo sp_helpconstraint objname=Shipmentgo sp_helpconstraint objname=ShippingModego sp_helpconstraint objname=ShippingRatego sp_helpconstraint objname=Shoppergo sp_helpconstraint objname=ShoppingCartgo sp_helpconstraint objname=ToyBrandgosp_helpconstraint objname=Toysgo sp_helpconstraint objname=Wrapper； */ 4． create type xianke from char(3)alter table Recipient alter column cCountryId kkalter table Countryalter column cCountryId kk5.USE GlobalToyzGOCREATE TABLE PremiumToys ( cToyId char(6) primary key, vToyName varchar(20) not null, vToyDescription varchar(250), cCategoryId char(3) , mToyRate money not null, cBrandId char(3), imPhoto image, siToyQoh smallint not null, siLowerAge smallint not null, siUpperAge smallint not null, siToyWeight smallint, vToyImgPath varchar(50) null ) INSERT INTO PremiumToys SELECT * FROM Toys WHERE mToyRate20.ALTER Table Toys ADD siToyQoh smallint CHECK（siToyQoh=0 AND siToyQoh=200）,ALTER TABLE Toys ADD siLowerAge smallint CHECK(siLowerAge=’1’),ALTER TABLE Toys ADD mToyRate CHECK (mToyRate0)ALTER TABLE Toys ADD siToyWeight CHECK(siToyWeigh=’1’)(cToyId char(6) primary key,vToyName varchar(20) not null, vToyDescripti
規(guī)章制度相關(guān)推薦
鄂ICP備17016276號-1