Sp_Sales_SalesAnalysiseOfMonth.md 1.11 KB

Sp_Sales_SalesAnalysiseOfMonth (procedure)

  • Type: PROCEDURE
  • Deterministic: NO
  • SQL data access: CONTAINS SQL

Parameters

# Mode Name Type
1 IN sStatistics varchar(100)
2 IN tStartDate datetime
3 IN tEndDate datetime
4 IN iBillType int
5 IN iClassifyType int
6 IN iSum int
7 IN iGetContent int
8 IN sLogin varchar(100)
9 IN sBrId varchar(100)
10 IN sSuId varchar(100)
11 IN bFilter varchar(5000)
12 IN pageNum int
13 IN pageSize int
14 OUT totalCount int
15 IN countCloumn varchar(5000)
16 OUT countMapJson longtext
17 IN sFilterOrderBy varchar(5000)
18 IN sGroupby_select_sql varchar(5000)
19 IN sGroupby_group_sql varchar(5000)

Body

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

Narrative

No human-written narrative yet.