使用syntaxhighlighter插件对代码进行加亮:
1>下载syntaxhighlighter,解压后将shThemeDefault.css和shCoreRDark.css文件上传到博客园
2>设置"页首html代码",添加
<link type="text/css" rel="stylesheet" href="http://博客地址/files/wbbice/shCoreRDark.css"/> <link type="text/css" rel="stylesheet" href="http://博客地址/files/wbbice/shThemeRDark.css"/>
2>引入高亮[注:将"<"替换成"<"]
<div class="cnblogs_Highlighter"> <pre class="brush:sql;gutter:true;"> 自己的代码 </pre> </div>
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‘)A LEFT JOIN U9_20160531_0800_1000ms_usedtables B ON A.EventSequence=B.eventsequence ;
原文：http://www.cnblogs.com/wbbice/p/5596095.html