摘要:
CREATE DEFINER=`wpsuper`@`%` TRIGGER `o2oinsert` BEFORE INSERT ON `t_s_o2o`FOR EACH ROW begin set New.fbianhao=(select fprojectval from t_billCodeRule 阅读全文
摘要:
select * from ICStockbill where fbillno='JIN002104' exec [xp_ICStockbill_29] 1862,3483,2000,250,'16421','JIN002104' select * from icstockbill where FB 阅读全文
摘要:
select sum(FQty) from ICInventory where FItemID=''SELEct FSupplyID,* from ICSubContract where FBillNo='LG2016102011'SELECT FQtyScrap , fitemid ,FAuxSt 阅读全文
摘要:
select sum(FQty) from ICInventory where FItemID=''SELEct FSupplyID,* from ICSubContract where FBillNo='LGSC20170098'SELECT FQtyScrap , fitemid FROM PP 阅读全文