博客园代码高亮

使用syntaxhighlighter插件对代码进行加亮:

1>下载syntaxhighlighter,解压后将shThemeDefault.css和shCoreRDark.css文件上传到博客园

2>设置"页首html代码",添加

1 2	<link type="text/css" rel="stylesheet" href="http://博客地址/files/wbbice/shCoreRDark.css"/> <link type="text/css" rel="stylesheet" href="http://博客地址/files/wbbice/shThemeRDark.css"/>

3>引入高亮[注:插入xml代码时需要将"<"替换成"&lt;"]

1 2 3 4 5

<div class="cnblogs_Highlighter"> <pre class="brush:sql;gutter:true;"> 自己的代码 </pre> </div>

4>示例代码:SQL

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

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 ;

参考链接:

http://www.cnblogs.com/nianyuwen/p/4255022.html

http://www.tuicool.com/articles/MnAJJvf

http://www.diguage.com/archives/59.html

http://www.cnblogs.com/heyuquan/archive/2012/09/28/2707632.html