SqlTool/Scripts/SL/操作日志查询.sql

SELECT
	*
FROM
	SL_sys_Schema.OperationLog ( nolock ) AS l
	LEFT JOIN SL_sys_Schema.OperationLogDetail ( nolock ) AS det ON det.LogId= l.LogId

	where PkVal='fbfa066aec4247ab865c47a9bd48b98f'
	and l.CreatedOn BETWEEN '2019-11-08' and '2019-12-12'
	and det.CreatedOn BETWEEN '2019-11-08' and '2019-12-12'
	order by l.CreatedOn