叮当技术

用户操作

[留言] [发消息] [加为好友]

订阅我的博客

[编辑]zhanghaibin的公告

<center> <hr>   <SPAN > <SCRIPT language=javascript> document.write ("<marquee scrollamount='1' scrolldelay='45' direction= 'UP' width='158' id='helpor_net' height='100' onmouseover='helpor_net.stop()' onmouseout='helpor_net.start()' Author:redriver; For more,visit:http://blog.csdn.net/litp>") document.write ("<br>相信自己，") document.write ("<br>挑战自己") document.write ("<br>战胜自己") document.write ("<br>完善自己") document.write ("</marquee> ") </SCRIPT> </SPAN> </center>  <center> <font color = blue style='FONT-SIZE:10pt'> 您是第 <script src="http://www.xcinfo.ha.cn/jsq/default.asp?User=zhanghaibin&Length=6&x=15&y=20&Mode=002"> </script>位访客</font> </center><br>  <center> <a href="http://blog.csdn.net/zhanghaibin"> <font color = blue style='FONT-SIZE:10pt'> 当前共有<script src=http://fastonlineusers.com/online.php?d=http://blog.csdn.net/zhanghaibin></script>位网友在看此Blog</a> <br> </font></center>

[编辑]文章分类

[编辑]友情链接

Litp (RSS)

博客园

存档

一条SQL语句实现归档功能收藏

SELECT COUNT(*) AS CNT,str(DATEPART(year, postTime))+str(DATEPART(month, postTime)) as ym
FROM contentArticle
GROUP BY str(DATEPART(year, postTime))+str(DATEPART(month, postTime))

得到的结果将是