二进制排序规则下-汉字字典排序 - Linux安全网 - Linux操作系统_Linux 命令_Linux教程

易飞的数据库是采取二进制排序规则，在统计小计和总计过程,位置出现偏差。
小-X,总-Z 应该会在相对后面才OK的。参照百度做法
处理方法:
一、首先准备一个拼音表
CREATE TABLE aword(
 PY varchar(10),
 ZW nvarchar(10)
) ON [PRIMARY]
GO
--插入数据
insert into aword
select 'A',N'骜'
union all select 'B',N'簿' 
union all select 'C',N'错' 
union all select 'D',N'鵽' 
union all select 'E',N'樲' 
union all select 'F',N'鳆' 
union all select 'G',N'腂' 
union all select 'H',N'夻' 
union all select 'J',N'攈' 
union all select 'K',N'穒' 
union all select 'L',N'鱳' 
union all select 'M',N'旀' 
union all select 'N',N'桛' 
union all select 'O',N'沤' 
union all select 'P',N'曝' 
union all select 'Q',N'囕' 
union all select 'R',N'鶸' 
union all select 'S',N'蜶' 
union all select 'T',N'箨' 
union all select 'W',N'鹜' 
union all select 'X',N'鑂' 
union all select 'Y',N'韵' 
union all select 'Z',N'咗'
GO
</pre></blockquote>
<p><br>
二、建立一个获取拼音首字母的函数</p>
<textarea readonly name="code"class="sql" >create fu<a href='http://www.linuxso.com/command/nc.html' target='_blank'><u>nc</u></a>tion f_GetPY
(
 @s<a href='http://www.linuxso.com/command/tr.html' target='_blank'><u>tr</u></a> nvarchar(2)
) 
returns nvarchar(2)
as 
begin
 <a href='http://www.linuxso.com/command/set.html' target='_blank'><u>set</u></a> @str = left(@str, 1)
 return (
  case when unicode(@str) between 19968 and 19968+20901 then(
   select top 1 PY+'.' from aword where ZW>=@str 
   <a href='http://www.linuxso.com/command/col.html' target='_blank'><u>col</u></a>late Chinese_PRC_CS_AS_KS_WS order by PY ASC
  ) e<a href='http://www.linuxso.com/command/ls.html' target='_blank'><u>ls</u></a>e @str end
 )
end
GO

</pre></blockquote>
<p><br>
三、存储过程</p>
<textarea readonly name="code"class="sql" >set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

-- =============================================      
-- Author: <Dav<a href='http://www.linuxso.com/command/id.html' target='_blank'><u>id</u></a> Gong>      
-- Create <a href='http://www.linuxso.com/command/date.html' target='_blank'><u>date</u></a>: <2011-12-08>      
-- Description: <统计每月供应商、材料类别分布情况>      
-- =============================================  

ALTER Proce<a href='http://www.linuxso.com/command/du.html' target='_blank'><u>du</u></a>re [dbo].[UP_POPlan]
(
  @year as char(4)='2011'
)
as
begin
declare  @plan Table
(
   <a href='http://www.linuxso.com/command/cat.html' target='_blank'><u>cat</u></a>egory nvarchar(20)
  ,<a href='http://www.linuxso.com/command/su.html' target='_blank'><u>su</u></a>pplier nvarchar(20)
  ,acct_m01 decimal(18,2)
  ,acct_m02 decimal(18,2)
  ,acct_m03 decimal(18,2)
  ,acct_m04 decimal(18,2)
  ,acct_m05 decimal(18,2)
  ,acct_m06 decimal(18,2)
  ,acct_m07 decimal(18,2)
  ,acct_m08 decimal(18,2)
  ,acct_m09 decimal(18,2)
  ,acct_m10 decimal(18,2)
  ,acct_m11 decimal(18,2)
  ,acct_m12 decimal(18,2)
)
declare  @planbycategory Table
(
   category nvarchar(20)
  ,supplier nvarchar(20)
  ,acct_m01 decimal(18,2)
  ,acct_m02 decimal(18,2)
  ,acct_m03 decimal(18,2)
  ,acct_m04 decimal(18,2)
  ,acct_m05 decimal(18,2)
  ,acct_m06 decimal(18,2)
  ,acct_m07 decimal(18,2)
  ,acct_m08 decimal(18,2)
  ,acct_m09 decimal(18,2)
  ,acct_m10 decimal(18,2)
  ,acct_m11 decimal(18,2)
  ,acct_m12 decimal(18,2)
)
Insert into @plan(category,supplier,acct_m01)select  left(TC004,2) as category ,MA002 as supplier,(TC019+TC020) as amount from PURTC
inner <a href='http://www.linuxso.com/command/join.html' target='_blank'><u>join</u></a> PURMA on MA001=TC004
where left(TC003,4)=@year and substring(TC003,5,2)='01'
Insert into @plan(category,supplier,acct_m02)select  left(TC004,2) as category ,MA002 as supplier,(TC019+TC020) as amount from PURTC
inner join PURMA on MA001=TC004
where left(TC003,4)=@year and substring(TC003,5,2)='02'
Insert into @plan(category,supplier,acct_m03)select  left(TC004,2) as category ,MA002 as supplier,(TC019+TC020) as amount from PURTC
inner join PURMA on MA001=TC004
where left(TC003,4)=@year and substring(TC003,5,2)='03'
Insert into @plan(category,supplier,acct_m04)select  left(TC004,2) as category ,MA002 as supplier,(TC019+TC020) as amount from PURTC
inner join PURMA on MA001=TC004
where left(TC003,4)=@year and substring(TC003,5,2)='04'
Insert into @plan(category,supplier,acct_m05)select  left(TC004,2) as category ,MA002 as supplier,(TC019+TC020) as amount from PURTC
inner join PURMA on MA001=TC004
where left(TC003,4)=@year and substring(TC003,5,2)='05'
Insert into @plan(category,supplier,acct_m06)select  left(TC004,2) as category ,MA002 as supplier,(TC019+TC020) as amount from PURTC
inner join PURMA on MA001=TC004
where left(TC003,4)=@year and substring(TC003,5,2)='06'
Insert into @plan(category,supplier,acct_m07)select  left(TC004,2) as category ,MA002 as supplier,(TC019+TC020) as amount from PURTC
inner join PURMA on MA001=TC004
where left(TC003,4)=@year and substring(TC003,5,2)='07'
Insert into @plan(category,supplier,acct_m08)select  left(TC004,2) as category ,MA002 as supplier,(TC019+TC020) as amount from PURTC
inner join PURMA on MA001=TC004
where left(TC003,4)=@year and substring(TC003,5,2)='08'
Insert into @plan(category,supplier,acct_m09)select  left(TC004,2) as category ,MA002 as supplier,(TC019+TC020) as amount from PURTC
inner join PURMA on MA001=TC004
where left(TC003,4)=@year and substring(TC003,5,2)='09'
Insert into @plan(category,supplier,acct_m10)select  left(TC004,2) as category ,MA002 as supplier,(TC019+TC020) as amount from PURTC
inner join PURMA on MA001=TC004
where left(TC003,4)=@year and substring(TC003,5,2)='10'
Insert into @plan(category,supplier,acct_m11)select  left(TC004,2) as category ,MA002 as supplier,(TC019+TC020) as amount from PURTC
inner join PURMA on MA001=TC004
where left(TC003,4)=@year and substring(TC003,5,2)='11'
Insert into @plan(category,supplier,acct_m12)select  left(TC004,2) as category ,MA002 as supplier,(TC019+TC020) as amount from PURTC
inner join PURMA on MA001=TC004
where left(TC003,4)=@year and substring(TC003,5,2)='12'

--分组合计
Insert into @planbycategory(category,supplier,acct_m01,acct_m02,acct_m03,acct_m04,acct_m05,acct_m06,acct_m07,acct_m08,acct_m09,acct_m10,acct_m11,acct_m12)
select  
        case when category='01' then 'LCD'
			  when category='02' then 'BL'
		      when category='03' then 'PCB'
		      when category='04' then 'IC'
		      when category='05' then '金属件'
		      when category='06' then '连接器'
		      when category='07' then '电子元器件'
		      when category='08' then '辅料'
		      when category='09' then '继电器'
		      when category='98' then '设备'
              else '其他' end category ,
            '总计' as supplier ,
	    convert(decimal(19,2),sum(isnull(acct_m01,0))) as 一月,
		convert(decimal(19,2),sum(isnull(acct_m02,0))) as 二月,
		convert(decimal(19,2),sum(isnull(acct_m03,0))) as 三月,
		convert(decimal(19,2),sum(isnull(acct_m04,0))) as 四月,
        convert(decimal(19,2),sum(isnull(acct_m05,0))) as 五月,
        convert(decimal(19,2),sum(isnull(acct_m06,0))) as 六月,
        convert(decimal(19,2),sum(isnull(acct_m07,0))) as 七月,
        convert(decimal(19,2),sum(isnull(acct_m08,0))) as 八月,
        convert(decimal(19,2),sum(isnull(acct_m09,0))) as 九月,
        convert(decimal(19,2),sum(isnull(acct_m10,0))) as 十月,
        convert(decimal(19,2),sum(isnull(acct_m11,0))) as 十一月,
        convert(decimal(19,2),sum(isnull(acct_m12,0))) as 十二月
from @plan
group by category

select a.category,a.supplier,a.一月,a.二月,a.三月,a.四月,a.五月,a.六月,a.七月,a.八月,a.九月,a.十月,a.十一月,a.十二月,
(a.一月+a.二月+a.三月+a.四月+a.五月+a.六月+a.七月+八月+九月+十月+十一月+十二月) as 合计
 from (
select  
        case when category='01' then 'LCD'
			  when category='02' then 'BL'
		      when category='03' then 'PCB'
		      when category='04' then 'IC'
		      when category='05' then '金属件'
		      when category='06' then '连接器'
		      when category='07' then '电子元器件'
		      when category='08' then '辅料'
		      when category='09' then '继电器'
		      when category='98' then '设备'
              else '其他' end category ,
        supplier,
	    convert(decimal(19,2),sum(isnull(acct_m01,0))) as 一月,
		convert(decimal(19,2),sum(isnull(acct_m02,0))) as 二月,
		convert(decimal(19,2),sum(isnull(acct_m03,0))) as 三月,
		convert(decimal(19,2),sum(isnull(acct_m04,0))) as 四月,
        convert(decimal(19,2),sum(isnull(acct_m05,0))) as 五月,
        convert(decimal(19,2),sum(isnull(acct_m06,0))) as 六月,
        convert(decimal(19,2),sum(isnull(acct_m07,0))) as 七月,
        convert(decimal(19,2),sum(isnull(acct_m08,0))) as 八月,
        convert(decimal(19,2),sum(isnull(acct_m09,0))) as 九月,
        convert(decimal(19,2),sum(isnull(acct_m10,0))) as 十月,
        convert(decimal(19,2),sum(isnull(acct_m11,0))) as 十一月,
        convert(decimal(19,2),sum(isnull(acct_m12,0))) as 十二月
from @plan
group by category,supplier
--小组合计 
union all
select * from @planbycategory
--总计
union all
select '总计' as category,
        '总计' as supplier,
	    convert(decimal(19,2),sum(isnull(acct_m01,0))) as 一月,
		convert(decimal(19,2),sum(isnull(acct_m02,0))) as 二月,
		convert(decimal(19,2),sum(isnull(acct_m03,0))) as 三月,
		convert(decimal(19,2),sum(isnull(acct_m04,0))) as 四月,
        convert(decimal(19,2),sum(isnull(acct_m05,0))) as 五月,
        convert(decimal(19,2),sum(isnull(acct_m06,0))) as 六月,
        convert(decimal(19,2),sum(isnull(acct_m07,0))) as 七月,
        convert(decimal(19,2),sum(isnull(acct_m08,0))) as 八月,
        convert(decimal(19,2),sum(isnull(acct_m09,0))) as 九月,
        convert(decimal(19,2),sum(isnull(acct_m10,0))) as 十月,
        convert(decimal(19,2),sum(isnull(acct_m11,0))) as 十一月,
        convert(decimal(19,2),sum(isnull(acct_m12,0))) as 十二月
from @planbycategory

) a
order by dbo.f_GetPY(a.category) , dbo.f_GetPY(a.supplier) ASC

END 
</pre></blockquote>
<p>查询结果</p>
<p><img alt="" src="/uploads/allimg/111209/0ZA01392-0.gif"><br>
</p>
                
               <span class="contenttop" style=" width:682px;float:left; text-align:center">
<script type="text/javascript"><!--
google_ad_client = "ca-pub-4510523863108853";
/* 300x250, 创建于 11-4-9 */
google_ad_slot = "4993518163";
google_ad_width = 300;
google_ad_height = 250;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<script type="text/javascript">/*336*280，用于并排和google*/ var cpro_id = 'u658144';</script><script src="http://cpro.baidu.com/cpro/ui/c.js" type="text/javascript"></script>
  </span>             

            </div>

            

            <div class="dede_pages">

				<ul class="pagelist">

          

				</ul>
            
			</div> <br>



            <div class="text_tag">



                        <h5>Tags： </h5>



<span class="jiathiswidget" id="ckepop">

                <span class="label">分享至:</span>

                <a class="jiathis_button_tsina"></a>

                <a class="jiathis_button_tqq"></a>

                <a class="jiathis_button_qzone"></a>

                <a class="jiathis_button_baidu"></a>

                <a class="jiathis_button_renren"></a>

                <a class="jiathis_button_kaixin001"></a>

                <a class="jiathis_button_douban"></a>

                <a class="jiathis_button_xiaoyou"></a>

                <a href="http://www.jiathis.com/share?uid=1536270" class="jiathis jiathis_txt jtico jtico_jiathis" target="_blank"></a>

            </span>



            </div>



            



<div class="box_xgimg"> 



<script type="text/javascript">



    var t_u = null;



    var t_u_old = null;



    var maxPic = 6;



    var showPic = 0;







    function switchPic(curPic){ 



        if(curPic == maxPic){ 



            showPic = 1;



        }else{ 



            showPic = showPic + 1;



        }



        for(i=1; i <= maxPic; i++){ 



            if(i == showPic){ 



                document.getElementById("picA"+i).className = "currON";



                document.getElementById("picUL"+i).style.display = "";



            }else{ 



                document.getElementById("picA"+i).className = "";



                document.getElementById("picUL"+i).style.display = "none";



            }



        }



    }



    function reSwitchPic() { 



        clearTimeout(t_u);



        switchPic(showPic);



        t_u = setTimeout('reSwitchPic();', 5000);



    }



    function pauseSwitch() { 



        clearTimeout(t_u);



        t_u_old = t_u;



    }



    function selectSwitch(num) { 



        showPic = num;



        for(i=1; i <= maxPic; i++){ 



            if(i == num){ 



                document.getElementById("picA"+i).className = "currON";



                document.getElementById("picUL"+i).style.display = "";



            }else{ 



                document.getElementById("picA"+i).className = "";



                document.getElementById("picUL"+i).style.display = "none";



            }



        }



    }



    function goonSwitch() {



        clearTimeout(t_u);



        t_u = setTimeout('reSwitchPic();', 5000);



    }   



</script>



<div class="title_xg">



    <div style="float:left;padding-left:-10px;text-align:left;"><b>最新图文资讯</b></div>



    <span style="float:right;padding-right:10px;font-size:12px;font-weight:normal;">



        <a href="javascript://" class="currON" id="picA1" onclick="selectSwitch(1)" onmouseover="pauseSwitch()" onmouseout="goonSwitch()">1</a>



        <a href="javascript://"  id="picA2"  onclick="selectSwitch(2)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">2</a>



        <a href="javascript://"  id="picA3"  onclick="selectSwitch(3)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">3</a>



        <a href="javascript://"  id="picA4"  onclick="selectSwitch(4)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">4</a>



        <a href="javascript://"  id="picA5"  onclick="selectSwitch(5)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">5</a>



        <a href="javascript://"  id="picA6"  onclick="selectSwitch(6)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">6</a>



    </span>



</div>



<div class="roll" id="roll" style="margin-left:0px;padding-left:0px;">



    <ul id="picUL1" onmouseover="pauseSwitch()" onmouseout="goonSwitch()">

		<li>

			<div><a href="/sql/13469.html"><img src='/uploads/allimg/111217/09111M624-0-lp.gif' border='0' width='121' height='91' alt='Oracle AWR 报告中 No data exists for this section of the rep'></a></div>

			<p><a  href="/sql/13469.html">Oracle AWR 报告中 No data exists for this section of the rep</a></p>

			</li>
<li>

			<div><a href="/sql/13461.html"><img src='/uploads/allimg/111217/09105SA5-0-lp.gif' border='0' width='121' height='91' alt='SQLserver数据库中的文件和文件组'></a></div>

			<p><a  href="/sql/13461.html">SQLserver数据库中的文件和文件组</a></p>

			</li>
<li>

			<div><a href="/sql/13324.html"><img src='/uploads/allimg/111216/110933DN-0-lp.gif' border='0' width='121' height='91' alt='Oracle JOB异常ORA-06512'></a></div>

			<p><a  href="/sql/13324.html">Oracle JOB异常ORA-06512</a></p>

			</li>
<li>

			<div><a href="/sql/13170.html"><img src='/uploads/allimg/111215/11463U139-0-lp.jpg' border='0' width='121' height='91' alt='PostgreSQL之精妙的数据库导入导出工具架构 （十）'></a></div>

			<p><a  href="/sql/13170.html">PostgreSQL之精妙的数据库导入导出工具架构 （十）</a></p>

			</li>


	</ul>



    <ul id="picUL2" onmouseover="pauseSwitch()" onmouseout="goonSwitch()" style="display:none;">

		<li>

			<div><a href="/sql/13089.html"><img src='/uploads/allimg/111214/221T12129-0-lp.gif' border='0' width='121' height='91' alt='vi/vim学习的必备键盘图'></a></div>

			<p><a  href="/sql/13089.html">vi/vim学习的必备键盘图</a></p>

			</li>
<li>

			<div><a href="/sql/13079.html"><img src='/uploads/allimg/111214/221R43Q6-0-lp.gif' border='0' width='121' height='91' alt='Oracle DBCA 命令 进行实例 复制 说明'></a></div>

			<p><a  href="/sql/13079.html">Oracle DBCA 命令 进行实例 复制 说明</a></p>

			</li>
<li>

			<div><a href="/sql/12915.html"><img src='/uploads/allimg/111214/1253332536-0-lp.gif' border='0' width='121' height='91' alt='sql server:sql动态行转列(pivot) 例子'></a></div>

			<p><a  href="/sql/12915.html">sql server:sql动态行转列(pivot) 例子</a></p>

			</li>
<li>

			<div><a href="/sql/12907.html"><img src='/uploads/allimg/111214/12531VW8-0-lp.gif' border='0' width='121' height='91' alt='sqlserver2000 导出数据至 oracle'></a></div>

			<p><a  href="/sql/12907.html">sqlserver2000 导出数据至 oracle</a></p>

			</li>


    </ul>



    <ul id="picUL3" onmouseover="pauseSwitch()" onmouseout="goonSwitch()" style="display:none;">

		<li>

			<div><a href="/sql/12797.html"><img src='/uploads/allimg/111213/1006364624-0-lp.gif' border='0' width='121' height='91' alt='看Sybase官方手册学索引工作原理'></a></div>

			<p><a  href="/sql/12797.html">看Sybase官方手册学索引工作原理</a></p>

			</li>
<li>

			<div><a href="/sql/12667.html"><img src='/uploads/allimg/111212/164J341U-0-lp.gif' border='0' width='121' height='91' alt='mysql 实现时统计 hql'></a></div>

			<p><a  href="/sql/12667.html">mysql 实现时统计 hql</a></p>

			</li>
<li>

			<div><a href="/sql/12625.html"><img src='/uploads/allimg/111212/0Z21W561-0-lp.JPG' border='0' width='121' height='91' alt='SQL Server死锁总结'></a></div>

			<p><a  href="/sql/12625.html">SQL Server死锁总结</a></p>

			</li>
<li>

			<div><a href="/sql/12603.html"><img src='/uploads/allimg/111211/1J6024292-0-lp.gif' border='0' width='121' height='91' alt='Oracle 11g R2 RAC 安装时 系统用户组 配置 说明'></a></div>

			<p><a  href="/sql/12603.html">Oracle 11g R2 RAC 安装时 系统用户组 配置 说明</a></p>

			</li>


    </ul>



    <ul id="picUL4" onmouseover="pauseSwitch()" onmouseout="goonSwitch()" style="display:none;">

		<li>

			<div><a href="/sql/12528.html"><img src='/uploads/allimg/111211/12395Q635-0-lp.gif' border='0' width='121' height='91' alt='Oracle 11g 行列互换  pivot 和 unpivot 说明'></a></div>

			<p><a  href="/sql/12528.html">Oracle 11g 行列互换  pivot 和 unpivot 说明</a></p>

			</li>
<li>

			<div><a href="/sql/12499.html"><img src='/uploads/allimg/111210/2009143A9-0-lp.gif' border='0' width='121' height='91' alt='我的2011：个人职业发展的三个里程碑'></a></div>

			<p><a  href="/sql/12499.html">我的2011：个人职业发展的三个里程碑</a></p>

			</li>
<li>

			<div><a href="/sql/12497.html"><img src='/uploads/allimg/111210/200Z55494-0-lp.gif' border='0' width='121' height='91' alt='SQL SERVER2008日常自动化备份'></a></div>

			<p><a  href="/sql/12497.html">SQL SERVER2008日常自动化备份</a></p>

			</li>
<li>

			<div><a href="/sql/12332.html"><img src='/uploads/allimg/111210/00132G959-0-lp.png' border='0' width='121' height='91' alt='pg启动过程中的那些事三：加载GUC参数'></a></div>

			<p><a  href="/sql/12332.html">pg启动过程中的那些事三：加载GUC参数</a></p>

			</li>


    </ul>



    <ul id="picUL5" onmouseover="pauseSwitch()" onmouseout="goonSwitch()" style="display:none;">

		<li>

			<div><a href="/sql/12331.html"><img src='/uploads/allimg/111210/0013233229-0-lp.gif' border='0' width='121' height='91' alt='SQL Server 2008开启sa账户以及如何用JDBC进行连接 .'></a></div>

			<p><a  href="/sql/12331.html">SQL Server 2008开启sa账户以及如何用JDBC进行连接 .</a></p>

			</li>
<li>

			<div><a href="/sql/12329.html"><img src='/uploads/allimg/111210/00131T355-0-lp.png' border='0' width='121' height='91' alt='pg的内存管理机制二：AllocSet/MemoryContext的内存回收'></a></div>

			<p><a  href="/sql/12329.html">pg的内存管理机制二：AllocSet/MemoryContext的内存回收</a></p>

			</li>
<li>

			<div><a href="/sql/12164.html"><img src='/uploads/allimg/111209/115Z33Z2-0-lp.gif' border='0' width='121' height='91' alt='ASE12.5.4  Error: 2823接着报current process infected with 11'></a></div>

			<p><a  href="/sql/12164.html">ASE12.5.4  Error: 2823接着报current process infected with 11</a></p>

			</li>
<li>

			<div><a href="/sql/12066.html"><img src='/uploads/allimg/111209/0ZA01206-0-lp.gif' border='0' width='121' height='91' alt='latch:library cache 引起的数据库短暂hang（BUG 7122093）'></a></div>

			<p><a  href="/sql/12066.html">latch:library cache 引起的数据库短暂hang（BUG 7122093）</a></p>

			</li>


    </ul>



    <ul id="picUL6" onmouseover="pauseSwitch()" onmouseout="goonSwitch()" style="display:none;">

		<li>

			<div><a href="/sql/12081.html"><img src='/uploads/allimg/111209/0ZH1IT-0-lp.gif' border='0' width='121' height='91' alt='Navicat8.0 for mysql 安装包和注册码'></a></div>

			<p><a  href="/sql/12081.html">Navicat8.0 for mysql 安装包和注册码</a></p>

			</li>
<li>

			<div><a href="/sql/12113.html"><img src='/uploads/allimg/111209/0ZQKY9-0-lp.gif' border='0' width='121' height='91' alt='Hibernate笔记'></a></div>

			<p><a  href="/sql/12113.html">Hibernate笔记</a></p>

			</li>
<li>

			<div><a href="/sql/12106.html"><img src='/uploads/allimg/111209/0ZP4I26-0-lp.gif' border='0' width='121' height='91' alt='sql server 2005 windows身份登陆 错误：18456'></a></div>

			<p><a  href="/sql/12106.html">sql server 2005 windows身份登陆 错误：18456</a></p>

			</li>
<li>

			<div><a href="/sql/12067.html"><img src='/uploads/allimg/111209/0ZA01392-0-lp.gif' border='0' width='121' height='91' alt='二进制排序规则下-汉字字典排序'></a></div>

			<p><a  href="/sql/12067.html">二进制排序规则下-汉字字典排序</a></p>

			</li>


    </ul>



    <script type="text/javascript">



    reSwitchPic();



    </script>



</div>



</div>   







                        <div class="box_xg">



                <div class="title_xg">相关文章列表:</div>



                <ul>

					<li><a href='/linuxrumen/13513.html'>linux iptables 保存 删除规则命令</a></li>
<li><a href='/linuxbiancheng/13340.html'>Python 的列表排序</a></li>
<li><a href='/linuxbiancheng/13336.html'>归并排序算法(递归实现)</a></li>
<li><a href='/linuxbiancheng/13171.html'>HDOJ 1285:确定比赛名次 拓扑排序</a></li>
<li><a href='/linuxbiancheng/13090.html'>归并排序</a></li>
<li><a href='/linuxbiancheng/13076.html'>希尔排序算法</a></li>
<li><a href='/linuxbiancheng/12932.html'>简单选择排序算法</a></li>
<li><a href='/linuxbiancheng/12918.html'>直接插入排序算法</a></li>


				</ul>



            </div>





<!-- //评论内容区 -->







<div id="pllshow">

          <form action="#" method="post" name="feedback">

          <input type="hidden" name="dopost" value="send" />

          <input type="hidden" name="comtype" value="comments">

          <input type="hidden" name="aid" value="3023" />

          <input type="hidden" name="fid" id='feedbackfid' value="0" />



验证码:<input type='text' name='validate' size='4' /><img src="/include/vdimgck.php" alt="点击我更换图片" id="validateimg"  style="height:15px;" title="点击我更换图片" onclick="this.src=this.src+'?'" />





<span class="float_right">理智评论文明上网，拒绝恶意谩骂</span>

<span id="userinfo">

用户名：<b id="nickname"></b>

<span id="anonymous"><label><input type="checkbox" name="notuser"  checked="checked" /> 匿名发表</label></span>

<input type="button" onClick='PostComment()' value="发表评论" class="btn" />				

</span> 

<!--<span style="display:none;" id="fastLoginDiv" value="0">

	<label class="cor-ccc">用户名：</label>

	<input type="text" class="input-text bor-gray"  name="username" id="loginUsername" value="" />

	<label>密码：</label>

	<input type="password" class="input-text bor-gray" name="password" id="loginPassword" />

	<input type="button" class="btn" onclick="login(); return false;" value="登录" />

</span>	 -->

<div class="bor">

<textarea name="msg" rows="6" cols="94" class="rev_textarea">