Whistle

查看sql记录

use master;
SELECT TOP 1000
ST.text AS ‘执行的SQL语句’,
QS.execution_count AS ‘执行次数’,
QS.total_elapsed_time AS ‘耗时’,
QS.total_logical_reads AS ‘逻辑读取次数’,
QS.total_logical_writes AS ‘逻辑写入次数’,
QS.total_physical_reads AS ‘物理读取次数’,
QS.creation_time AS ‘执行时间’ ,
QS.*
FROM sys.dm_exec_query_stats QS
CROSS APPLY
sys.dm_exec_sql_text(QS.sql_handle) ST
WHERE QS.creation_time >’2020-08-18′
ORDER BY
QS.total_elapsed_time DESC

查询工单：

use SHCZ;
select SGMRAA.*,
A.DBA002 as RAA004C,DAA002 as RAA005C, DEA002,DEA003,IBB013,IBA004,DFA002,B.DBA002 AS RAA037C,IBB005 AS IBB005C,RAA018 AS RAA018C,DEA057 from SGMRAA left join TPADBA AS A on A.DBA001=RAA004 left join TPADAA on DAA001=RAA005 left join TPADEA on DEA001=RAA015 left join DCSIBB on ( IBB001=RAA011) and ( IBB002=RAA012) and ( RAA010=’32’) left join DCSIBA on ( IBA001=IBB001) left join TPADFA on DFA001=IBA004 left join TPADBA AS B on B.DBA001=RAA037 where ( SGMRAA.RAA003 >= ‘20221011’ ) order by SGMRAA.RAA001

RAA001 单号

RAA002 性质

RAA003 开单日期

RAA004 经办人

RAA005 部门

RAA006 预计开工日期

RAA007 预计完工日期

RAA008 实际开工日期

RAA009 实际完工日期

RAA010 未知

RAA011 RAA012 前置单据

RAA015 主件品号

RAA018 生产数量

RAA019 已生产量

RAA020 应该是 完工码-已完工

RAA026 RAA027 需求计划

RAA005C 部门

DEA002 产品名称

DEA003 单位

IBB013 预交货日

IBA004 客户编码

DFA002

生产计划 (似乎无用)

use SHCZ;
Select SGMSAA.*,A.DBA002 as SAA004C,DAA002 as SAA005C,B.DBA002 as SAA014C from SGMSAA left join TPADBA A on A.DBA001=SAA004 left join TPADAA on DAA001=SAA005 left join TPADBA B on B.DBA001=SAA014 where ( SGMSAA.SAA003 >= ‘20221011’ ) order by SGMSAA.SAA001