摘要：
问题描述在上次偷袭了B军大本营之后，B军非常愤怒，正式向A军宣战。A军又获取了一些情报。B军有n个士兵，每个士兵有a[i]的生命值，以及b[i]的防御力。A军一共有m个士兵，第i个士兵，需要消耗k[i]的体力，造成p[i]点伤害。当然，如果A军派出第i个士兵... 阅读全文
SELECT A.TextData,A.Duration, A.SPID, A.ClientProcessID, A.IntegerData, A.EventSequence, B.tablename FROM (SELECT event_text, TextData, CONVERT(DECIMAL(18,2), CONVERT(FLOAT,Duration)/1000000) Duration, CPU, Reads, Writes, SPID, ClientProcessID, IntegerData, RowCounts, EventSequence, CONVERT(VARCHAR(12),StartTime,114)StartTime, CONVERT(VARCHAR(12),EndTime,114)EndTime, HostName, ApplicationName, ObjectName FROM U9_20160531_0800_1000ms LEFT JOIN int_to_event ON EventClass=event_code WHERE event_text='SP:StmtCompleted')AS A LEFT JOIN 20160531_0800_1000ms_usedtables AS B ON A.EventSequence=B.eventsequence ;
SELECT A.TextData,A.Duration, A.SPID, A.ClientProcessID, A.IntegerData, A.EventSequence, B.tablename FROM (SELECT event_text, TextData, CONVERT(DECIMAL(18,2), CONVERT(FLOAT,Duration)/1000000) Duration, CPU, Reads, Writes, SPID, ClientProcessID, IntegerData, RowCounts, EventSequence, CONVERT(VARCHAR(12),StartTime,114)StartTime, CONVERT(VARCHAR(12),EndTime,114)EndTime, HostName, ApplicationName, ObjectName FROM U9_20160531_0800_1000ms LEFT JOIN int_to_event ON EventClass=event_code WHERE event_text='SP:StmtCompleted')AS A LEFT JOIN 20160531_0800_1000ms_usedtables AS B ON A.EventSequence=B.eventsequence ;