Sp_Check_dOraQtyTs.md 943 Bytes

Edit Raw Blame History



Sp_Check_dOraQtyTs (procedure)


校验是否超过源单数量


Type: PROCEDURE

Deterministic: NO

SQL data access: CONTAINS SQL


Parameters


#
Mode
Name
Type


1
IN
sTableName
varchar(50)


2
IN
sCloumnQtyName
varchar(255)


3
IN
sSrcTableName
varchar(50)


4
IN
sSrcCloumnName
varchar(50)


5
IN
sSrcCloumnQtyName
varchar(255)


6
IN
sTsCloumnName
varchar(50)


7
IN
sTsCloumnNameCon
varchar(50)


8
IN
sTsTableName
varchar(50)


9
IN
sGuid
varchar(50)


10
IN
sBrId
varchar(50)


11
IN
sSuId
varchar(50)


12
OUT
sCode
int


13
OUT
sReturn
longtext


Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpCheck_dOraQtyTs'._


Narrative

No human-written narrative yet.