CSDN博客

img 21aspnet

网站信息统计的简单实现过程

发表于2004/10/24 23:46:00  1856人阅读

分类: ADO.NET

作者:pcsky


SQL语句如下:

SELECT DD.SumHits, AA.CountArt, CC.WeekUpdate, BB.RegUserNum
FROM
(SELECT COUNT(newsid) AS CountArt FROM article) AA,
(SELECT COUNT(id) AS RegUserNum FROM Admin) BB,
(SELECT COUNT(newsid) AS WeekUpdate FROM(article) WHERE DateDiff('ww', DateAndTime, Now()) >= 7) CC,
(SELECT SUM(hits) AS SumHits FROM Article) DD



运行环境:
VS.Net 2003
用OleDbConnection控件

其中用到了子表,因为分开来写不太方便
阅读全文
0 0

相关文章推荐

img
取 消
img