WISE 13.1升级到14.2报错问题
882次浏览
编辑于2016年09月26日 08:29:26
WISE 13.1升级到14.2以后存货核算报错如图
ALTER TABLE icstockbill DROP CONSTRAINT DF__ICStockBi__FPeer__77E1C164
go
ALTER TABLE icstockbill DROP COLUMN FPeerStateCancelVerification
go
ALTER TABLE icstockbill DROP COLUMN FBuyerMessage
go
ALTER TABLE icstockbill DROP COLUMN FDeliveryProvince
go
ALTER TABLE icstockbill DROP COLUMN FDeliveryCity
go
ALTER TABLE icstockbill DROP COLUMN FDeliveryDistrict
go
ALTER TABLE icstockbill DROP COLUMN FDeliveryAddress
go
ALTER TABLE icstockbill DROP COLUMN FBuyerNick
go
ALTER TABLE icstockbill DROP COLUMN FTelephone
go
ALTER TABLE icstockbill DROP COLUMN FMobile
go
ALTER TABLE icstockbill DROP COLUMN FSellerMessage
go
ALTER TABLE icstockbill DROP CONSTRAINT DF__ICStockBi__FWLNu__57CFB489
go
ALTER TABLE icstockbill DROP COLUMN FWLNumber
go
ALTER TABLE icstockbill DROP CONSTRAINT DF__ICStockBi__FWLCo__58C3D8C2
go
ALTER TABLE icstockbill DROP COLUMN FWLCompany
go
ALTER TABLE icstockbill DROP CONSTRAINT DF__ICStockBi__FShop__65562251
go
ALTER TABLE icstockbill DROP COLUMN FShopFManagerID
go
ALTER TABLE icstockbill DROP COLUMN FShopArriveDate
go
ALTER TABLE icstockbill DROP CONSTRAINT DF__ICStockBi__FWeiR__15053573
go
ALTER TABLE icstockbill DROP COLUMN FWeiRetail
go
ALTER TABLE icstockbillentry DROP COLUMN fneedpickqty
go
ALTER TABLE icstockbillentry DROP COLUMN FInvStockQty
go
ALTER TABLE icstockbillentry DROP CONSTRAINT DF__ICStockBi__FBuye__5BCF929B
go
ALTER TABLE icstockbillentry DROP COLUMN FBuyerFreight
go
ALTER TABLE icstockbill DROP CONSTRAINT DF__ICStockBi__FPeer__77E1C164
go
ALTER TABLE icstockbill DROP COLUMN FPeerStateCancelVerification
go
ALTER TABLE icstockbill DROP COLUMN FBuyerMessage
go
ALTER TABLE icstockbill DROP COLUMN FDeliveryProvince
go
ALTER TABLE icstockbill DROP COLUMN FDeliveryCity
go
ALTER TABLE icstockbill DROP COLUMN FDeliveryDistrict
go
ALTER TABLE icstockbill DROP COLUMN FDeliveryAddress
go
ALTER TABLE icstockbill DROP COLUMN FBuyerNick
go
ALTER TABLE icstockbill DROP COLUMN FTelephone
go
ALTER TABLE icstockbill DROP COLUMN FMobile
go
ALTER TABLE icstockbill DROP COLUMN FSellerMessage
go
ALTER TABLE icstockbill DROP CONSTRAINT DF__ICStockBi__FWLNu__57CFB489
go
ALTER TABLE icstockbill DROP COLUMN FWLNumber
go
ALTER TABLE icstockbill DROP CONSTRAINT DF__ICStockBi__FWLCo__58C3D8C2
go
ALTER TABLE icstockbill DROP COLUMN FWLCompany
go
ALTER TABLE icstockbill DROP CONSTRAINT DF__ICStockBi__FShop__65562251
go
ALTER TABLE icstockbill DROP COLUMN FShopFManagerID
go
ALTER TABLE icstockbill DROP COLUMN FShopArriveDate
go
ALTER TABLE icstockbill DROP CONSTRAINT DF__ICStockBi__FWeiR__15053573
go
ALTER TABLE icstockbill DROP COLUMN FWeiRetail
go
ALTER TABLE icstockbillentry DROP COLUMN fneedpickqty
go
ALTER TABLE icstockbillentry DROP COLUMN FInvStockQty
go
ALTER TABLE icstockbillentry DROP CONSTRAINT DF__ICStockBi__FBuye__5BCF929B
go
ALTER TABLE icstockbillentry DROP COLUMN FBuyerFreight
go
推荐阅读