检查了一下单据元数据默认行是200条
但是为什么fidentityid 能设置到1000000000 这么大的？？
SELECT * FROM (SELECT t0.FBILLNO fbillno, t0.FDATE fdate, t0.FISMARBLE fismarble, t0.FBATCHNAME fbatchname, t0.FMERGERNO fmergerno, t0.FRECEIPTADDRESS freceiptaddress_id, t0.FGROUPKEY fgroupkey, t0.FLOGISTICPOINT flogisticpoint_id, t0.FPACKQTYTOTAL fpackqtytotal, t0.FVOLUMETOTAL fvolumetotal, t0.FBOMVOLUMETOTAL fbomvolumetotal, t0.FBOMPACKSUMQTY fbompacksumqty, t0.FCREATORID fcreatorid_id, t0.FCREATEDATE fcreatedate, t0.FVISITSTATUS fvisitstatus, t0.FTEMPCHECKID ftempcheckid_id, t0.FGOODSCHECKID fgoodscheckid_id, t0.FGOODSLOCKID fgoodslockid_id, t0.FFEELOCKID ffeelockid_id, t0.FFEECHECKID ffeecheckid_id, t0.FPRINTLOCKER fprintlocker_id, t0.FPRINTSENDER fprintsender_id, t0.FPRINTRECORDER fprintrecorder_id, t5.FISGROUPGOODSAUDIT fisgroupgoodsaudit, t2.FMARKSTATUS fmarkstatus, t0.FID fid, ROW_NUMBER() OVER( ORDER BY t0.FID ASC) fidentityid FROM LS_T_SCM_TradeBatch t0 LEFT OUTER JOIN LS_T_SCM_BatchBus t2 ON t0.FID = t2.FID LEFT OUTER JOIN LS_T_SCM_MarkBatch t5 ON t0.FID = t5.FID) tlist WHERE ((fidentityid >= 1) AND (fidentityid <= 1000000000)) OPTION ( MAXDOP 0)
推荐阅读