用户5575279374的博客
<div id="bloglink" class="bloglink"><a href="http://blog.sina.com.cn/u/5575279374">http://blog.sina.com.cn/u/5575279374</a> <a onclick="return false;" class="CP_a_fuc" href="#" id="SubscribeNewRss">[<cite>订阅</cite>]</a><a class="CP_a_fuc" href="javascript:void(scope.pa_add.add('5575279374'));">[<cite>手机订阅</cite>]</a></div>
</div>
<div class="blognav" id="blognav">
<div id="blognavBg" class="blognavBg"></div> <div class="blognavInfo">
<span><a href="http://blog.sina.com.cn/u/5575279374">首页</a></span>
<span><a class="on" href="http://blog.sina.com.cn/s/articlelist_5575279374_0_1.html">博文目录</a></span>
<!--<span><a href="">图片</a></span>-->
<span class="last"><a href="http://blog.sina.com.cn/s/profile_5575279374.html">关于我</a></span></div>
</div>
<div class="autoskin" id="auto_skin">
</div>
<!--主题内容开始 -->
<div class="sinablogbody" id="sinablogbody">
<!--第一列start-->
<div id="column_1" class="SG_colW21 SG_colFirst"><div id="module_7" class="SG_conn">
<!--第二列start-->
<div id="column_2" class="SG_colW73"><div id="module_928" class="SG_conn">
<div class="SG_connHead">
<span comp_title="delphi_jiqiao<em>(58)</em>" class="title">delphi_jiqiao<em>(58)</em></span>
<span class="edit"> </span>
</div>
<div class="SG_connBody">
<div class="article_blk">
<div class="articleList">
<!-- 列表 START -->
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y9to.html">AV调教手册</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y9to">(<span title="评论数">0</span>/<span title="阅读数">22</span>)</span>
<span class="atc_tm SG_txtc">2017-08-28 18:36</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y88e.html">Delphi如何获取系统服务(即Service…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y88e">(<span title="评论数">0</span>/<span title="阅读数">36</span>)</span>
<span class="atc_tm SG_txtc">2017-08-26 18:56</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y9fd.html">Delphi fastmm内存机制 调试教程</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y9fd">(<span title="评论数">0</span>/<span title="阅读数">11</span>)</span>
<span class="atc_tm SG_txtc">2017-08-18 20:37</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y89l.html">Delphi Treeview 操作实例</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y89l">(<span title="评论数">0</span>/<span title="阅读数">22</span>)</span>
<span class="atc_tm SG_txtc">2017-08-16 23:03</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y975.html">[转载]DELPHI制作复杂报表实例,特…</a></span>
<span class="atc_ic_b"><img class="SG_icon SG_icon18" src="https://i-blog.csdnimg.cn/blog_migrate/a4c26d1e5885305701be709a3d33442f.gif" width="15" height="15" title="此博文包含图片" align="absmiddle"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y975">(<span title="评论数">0</span>/<span title="阅读数">9</span>)</span>
<span class="atc_tm SG_txtc">2017-08-10 23:37</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y96t.html">[转载]Delphi 与 XML 示例(直接利…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y96t">(<span title="评论数">0</span>/<span title="阅读数">11</span>)</span>
<span class="atc_tm SG_txtc">2017-08-10 23:27</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y96s.html">[转载]delphi读XML</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y96s">(<span title="评论数">0</span>/<span title="阅读数">6</span>)</span>
<span class="atc_tm SG_txtc">2017-08-10 23:26</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y96l.html">[转载]Delphi主从表例子 .</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y96l">(<span title="评论数">0</span>/<span title="阅读数">4</span>)</span>
<span class="atc_tm SG_txtc">2017-08-10 23:15</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y95f.html">[转载]Delphi 编程规范</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y95f">(<span title="评论数">0</span>/<span title="阅读数">12</span>)</span>
<span class="atc_tm SG_txtc">2017-08-09 21:06</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y88h.html">Delphi使用过程中的几个技巧</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y88h">(<span title="评论数">0</span>/<span title="阅读数">12</span>)</span>
<span class="atc_tm SG_txtc">2017-08-08 22:47</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y8bd.html">DELPHI 的 {$M +} 和{$M -}</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y8bd">(<span title="评论数">0</span>/<span title="阅读数">10</span>)</span>
<span class="atc_tm SG_txtc">2017-08-04 19:13</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y8be.html">用DELPHI 开发压缩、解压、自…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y8be">(<span title="评论数">0</span>/<span title="阅读数">23</span>)</span>
<span class="atc_tm SG_txtc">2017-08-04 19:13</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y7ip.html">dll窗体的创建与调用</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y7ip">(<span title="评论数">0</span>/<span title="阅读数">10</span>)</span>
<span class="atc_tm SG_txtc">2017-08-04 17:26</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y8bf.html">Delphi ADOQuery处理多条SQL语句</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y8bf">(<span title="评论数">0</span>/<span title="阅读数">12</span>)</span>
<span class="atc_tm SG_txtc">2017-08-04 12:39</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y8uu.html">动态产生器</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y8uu">(<span title="评论数">0</span>/<span title="阅读数">11</span>)</span>
<span class="atc_tm SG_txtc">2017-08-02 21:00</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y8uv.html">ASCII码表</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y8uv">(<span title="评论数">0</span>/<span title="阅读数">10</span>)</span>
<span class="atc_tm SG_txtc">2017-08-02 21:00</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y8xi.html">在delphi中TApplicationEvents控件…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y8xi">(<span title="评论数">0</span>/<span title="阅读数">1321</span>)</span>
<span class="atc_tm SG_txtc">2017-08-02 08:27</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y8uq.html">读写UTF-8、Unicode文件</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y8uq">(<span title="评论数">0</span>/<span title="阅读数">10</span>)</span>
<span class="atc_tm SG_txtc">2017-07-31 18:56</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y8up.html">delphi循环等待并继续处理其它消息</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y8up">(<span title="评论数">0</span>/<span title="阅读数">5</span>)</span>
<span class="atc_tm SG_txtc">2017-07-31 18:54</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y8hl.html">经典的调用窗口函数:调用融合窗口</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y8hl">(<span title="评论数">0</span>/<span title="阅读数">11</span>)</span>
<span class="atc_tm SG_txtc">2017-07-18 10:06</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y89k.html">delphi IOUtils单元 处…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y89k">(<span title="评论数">0</span>/<span title="阅读数">24</span>)</span>
<span class="atc_tm SG_txtc">2017-07-12 20:42</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y88v.html">Delphi Excel导入 的通用程序 .</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y88v">(<span title="评论数">0</span>/<span title="阅读数">10</span>)</span>
<span class="atc_tm SG_txtc">2017-07-12 18:39</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y87n.html">[转载]TStringList常用操作</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y87n">(<span title="评论数">0</span>/<span title="阅读数">17</span>)</span>
<span class="atc_tm SG_txtc">2017-07-12 12:59</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y87j.html">[转载]delphi中日期格式的设定</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y87j">(<span title="评论数">0</span>/<span title="阅读数">14</span>)</span>
<span class="atc_tm SG_txtc">2017-07-12 12:51</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y87i.html">[转载]在delphi中读取Excel数据</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y87i">(<span title="评论数">0</span>/<span title="阅读数">7</span>)</span>
<span class="atc_tm SG_txtc">2017-07-12 12:51</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y87e.html">[转载]Delphi中array of&nbsp…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y87e">(<span title="评论数">0</span>/<span title="阅读数">15</span>)</span>
<span class="atc_tm SG_txtc">2017-07-12 12:46</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y87a.html">在Delphi中创建的简单的Excel报表…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y87a">(<span title="评论数">0</span>/<span title="阅读数">20</span>)</span>
<span class="atc_tm SG_txtc">2017-07-12 12:39</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y85v.html">Delphi中JSon SuperObject&nb…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y85v">(<span title="评论数">0</span>/<span title="阅读数">587</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 23:12</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y84z.html">[转载]Delphi 的函数覆盖(Override…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y84z">(<span title="评论数">0</span>/<span title="阅读数">95</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 16:22</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y84w.html">[转载]Delphi中易混淆的概念 Owner…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y84w">(<span title="评论数">0</span>/<span title="阅读数">7</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 16:20</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y84u.html">[转载]DELPHI 中Format函数功能及…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y84u">(<span title="评论数">0</span>/<span title="阅读数">3</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 16:18</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y84l.html">[转载]Delphi Var参数的用法</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y84l">(<span title="评论数">0</span>/<span title="阅读数">18</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 16:05</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y84k.html">[转载]delphi destructor 析构函数</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y84k">(<span title="评论数">0</span>/<span title="阅读数">8</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 15:59</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y84j.html">[转载]Delphi Self总结</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y84j">(<span title="评论数">0</span>/<span title="阅读数">4</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 15:57</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y84h.html">[转载]Delphi 如何判断字符串是否…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y84h">(<span title="评论数">0</span>/<span title="阅读数">3</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 15:53</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y84f.html">[转载]Delphi 检查Delphi程序内存…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y84f">(<span title="评论数">0</span>/<span title="阅读数">11</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 15:52</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y84c.html">[转载]Delphi MessageBox封装</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y84c">(<span title="评论数">0</span>/<span title="阅读数">6</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 15:51</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y84a.html">[转载]Delphi高精度计时方法</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y84a">(<span title="评论数">0</span>/<span title="阅读数">10</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 15:50</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y843.html">[转载]Delphi的内存管理及内存泄露…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y843">(<span title="评论数">0</span>/<span title="阅读数">23</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 15:43</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y840.html">[转载]Delphi 判断第一个输入的是…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y840">(<span title="评论数">0</span>/<span title="阅读数">7</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 15:42</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y83z.html">[转载]Delphi 在Object Pascal中,…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y83z">(<span title="评论数">0</span>/<span title="阅读数">4</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 15:40</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y83x.html">[转载]DelphiStream对象</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y83x">(<span title="评论数">0</span>/<span title="阅读数">5</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 15:38</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y83r.html">[转载]delphi中的函数或者过程形参…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y83r">(<span title="评论数">0</span>/<span title="阅读数">20</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 15:34</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y83q.html">[转载]Delphi ADOQuery的速度…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y83q">(<span title="评论数">0</span>/<span title="阅读数">129</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 15:34</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y83p.html">[转载]Delphi 调试 通过BreakPoint</a></span>
<span class="atc_ic_b"><img class="SG_icon SG_icon18" src="https://i-blog.csdnimg.cn/blog_migrate/a4c26d1e5885305701be709a3d33442f.gif" width="15" height="15" title="此博文包含图片" align="absmiddle"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y83p">(<span title="评论数">0</span>/<span title="阅读数">0</span>)</span>
<span class="atc_tm SG_txtc">2017-07-11 15:33</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y7q3.html">自己写的一些Delphi常用函数3</a></span>
<span class="atc_ic_b"><img class="SG_icon SG_icon18" src="https://i-blog.csdnimg.cn/blog_migrate/a4c26d1e5885305701be709a3d33442f.gif" width="15" height="15" title="此博文包含图片" align="absmiddle"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y7q3">(<span title="评论数">0</span>/<span title="阅读数">6</span>)</span>
<span class="atc_tm SG_txtc">2017-07-04 20:29</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y7pz.html">自己写的一些Delphi常用函数1</a></span>
<span class="atc_ic_b"><img class="SG_icon SG_icon18" src="https://i-blog.csdnimg.cn/blog_migrate/a4c26d1e5885305701be709a3d33442f.gif" width="15" height="15" title="此博文包含图片" align="absmiddle"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y7pz">(<span title="评论数">0</span>/<span title="阅读数">3</span>)</span>
<span class="atc_tm SG_txtc">2017-07-04 20:19</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y7pv.html">自己写的一些Delphi常用函数</a></span>
<span class="atc_ic_b"><img class="SG_icon SG_icon18" src="https://i-blog.csdnimg.cn/blog_migrate/a4c26d1e5885305701be709a3d33442f.gif" width="15" height="15" title="此博文包含图片" align="absmiddle"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y7pv">(<span title="评论数">0</span>/<span title="阅读数">8</span>)</span>
<span class="atc_tm SG_txtc">2017-07-04 20:16</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y7p8.html">将中文字符串转换成 UTF8&nbs…</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y7p8">(<span title="评论数">0</span>/<span title="阅读数">8</span>)</span>
<span class="atc_tm SG_txtc">2017-07-04 12:33</span>
<span class="atc_set">
</span>
</p>
</div>
<div class="articleCell SG_j_linedot1">
<p class="atc_main SG_dot">
<span class="atc_ic_f"></span>
<span class="atc_title">
<a title="" target="_blank" href="http://blog.sina.com.cn/s/blog_14c50030e0102y7k3.html">Delphi指针运用理解</a></span>
<span class="atc_ic_b"></span>
</p>
<p class="atc_info">
<span class="atc_data" id="count_14c50030e0102y7k3">(<span title="评论数">1</span>/<span title="阅读数">7</span>)</span>
<span class="atc_tm SG_txtc">2017-06-30 20:22</span>
<span class="atc_set">
</span>
</p>
</div>
<!-- 列表END -->
</div>
<div class="SG_page">
<ul class="SG_pages">
<li class="SG_pgon" title="当前所在页">1</li><li><a href="http://blog.sina.com.cn/s/articlelist_5575279374_6_2.html" title="跳转至最后一页">2</a></li><li class="SG_pgnext"><a href="http://blog.sina.com.cn/s/articlelist_5575279374_6_2.html" title="跳转至第 2 页">下一页 ></a></li> <span style="color:#888888;">共2页</span> </ul>
</div>
</div>
<div class="SG_connFoot"></div>
</div>
</div></div>
<!--第二列start-->
<!--第三列start-->
<div id="column_3" class="SG_colWnone"><div style="width:0px;height:0.1px;margin:0px;"> </div></div>
<!--第三列end-->
<div id="articlebody" class="artical" favmd5="{"14d5a51a90102yqvr":"7191486dfb39933b66127ad5395fbc05"}">
<div class="articalTitle">
<h2 id="t_14d5a51a90102yqvr" class="titName SG_txta">如何快速发现和处理sqlserver数据库的死锁</h2>
<span class="img2">
<img width="15" height="15" align="absmiddle" title="此博文包含图片" src="https://i-blog.csdnimg.cn/blog_migrate/a4c26d1e5885305701be709a3d33442f.gif" class="SG_icon SG_icon18">
</span>
<span class="time SG_txtc">(2018-11-24 12:52:33)</span><div class="turnBoxzz"><a href="javascript:;" class="SG_aBtn SG_aBtn_ico SG_turn" action-type="reblog" action-data="{srcBlog:1, blogId:'14d5a51a90102yqvr'}"><cite><img class="SG_icon SG_icon111" src="https://i-blog.csdnimg.cn/blog_migrate/a4c26d1e5885305701be709a3d33442f.gif" width="15" height="15" align="absmiddle">转载<em class="arrow">▼</em></cite></a></div> </div>
<div class="articalTag" id="sina_keyword_ad_area">
<table>
<tbody><tr>
<td class="blog_tag">
<script>
var $tag='';
var $tag_code='0073979c943b4cc520b8f1ebb672022f';
var $r_quote_bligid='14d5a51a90102yqvr';
var $worldcup='0';
var $worldcupball='0';
</script>
</td>
<td class="blog_class">
<span class="SG_txtb">分类:</span>
<a target="_blank" href="http://blog.sina.com.cn/s/articlelist_5592732073_1_1.html">oracle</a>
</td>
</tr>
</tbody></table>
</div>
<!-- 正文开始 -->
<div id="sina_keyword_ad_area2" class="articalContent newfont_family">
<div>首先在sqlserver的查询分析器中查看特定数据库被阻塞的进程</div>
前些天写一个存储过程,存储过程中使用了事务,后来我把一些代码注释掉来进行调试找错,突然发现一张表被锁住了,原来是创建事务的代码忘记注释掉。本文表锁住了的解决方法。 其实不光是上面描述的情况会锁住表,还有很多种场景会使表放生死锁,解锁其实很简单,下面用一个示例来讲解: 1 首先创建一个测试用的表:
CREATE TABLE Test ( TID INT IDENTITY(1,1) )
2 执行下面的SQL语句将此表锁住:
SELECT * FROM Test WITH (TABLOCKX)
3 通过下面的语句可以查看当前库中有哪些表是发生死锁的:
SELECT request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName FROM sys.dm_tran_locks WHERE resource_type='OBJECT '
4 上面语句执行结果如下:
- spid :被锁进程ID。
- tableName:发生死锁的表名。
5 只需要使用kill关键字来杀掉被锁的进程ID就可以对表进行解锁:
KILL 52
SQL Server死锁的分析、处理与预防
1、基本原理
2、一个例子
3、检测与排查
3.1 通过Profile工具看死锁
3.2 通过系统存储过程看死锁
SELECT OBJECT_NAME(421666738) AS LockedResource,DB_NAME(11) AS DBName; -------------------------------------------------------------- LockedResource DBName -------------------------------------------------------------- tb_TE_SizeInformation JYBGDB
DBCC INPUTBUFFER(54); --------------------------------------------------------------------------- EventInfo EventType Parameters --------------------------------------------------------------------------- --根据事务的原子性实现个必要条件中 Language Event 0 --请求和等待 BEGIN TRAN --update语句在数据行上加排他锁 --和其它所有锁不兼容 --实现个必要条件中的:互斥 UPDATE tb_TE_BrandInformation SET IsCompensate=0 UPDATE tb_TE_SizeInformation SET [Description]=''
4、处理方式
4.1 SQL Server自动处理
服务器: |
事务(进程
4.2 Kill会话
Kill |
4.3 设定锁请求超时
SET LOCK_TIMEOUT |
服务器: 消息 1222,级别 16,状态 50,行 1 已超过了锁请求超时时段。 |
4.4 修改程序
4.5 升级硬件
5、如何预防
SELECT * FROM TABLE1 WITH(NOLOCK); SELECT * FROM TABLE2 WITH(NOLOCK); |
6、结束语