摘要：
** D : 字符串的展开** 时间限制: 1000 MS 内存限制: 32768 KB 在初赛普及组的“阅读程序写结果”的问题中，我们曾给出一个字符串展开的例子：... 阅读全文
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 ;