日期:2014-05-19  浏览次数:20613 次

新手上路,求助SQL循环
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=1   and   iAlarmType=0
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=1   and   iAlarmType=1
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=1   and   iAlarmType=2
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=1   and   iAlarmType=3
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=2   and   iAlarmType=0
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=2   and   iAlarmType=1
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=2   and   iAlarmType=2
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=2   and   iAlarmType=3
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=3   and   iAlarmType=0
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=3   and   iAlarmType=1
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=3   and   iAlarmType=2
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=3   and   iAlarmType=3
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=4   and   iAlarmType=0
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=4   and   iAlarmType=1
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=4   and   iAlarmType=2
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=4   and   iAlarmType=3
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=5   and   iAlarmType=0
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=5   and   iAlarmType=1
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=5   and   iAlarmType=2
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=5   and   iAlarmType=3
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=6   and   iAlarmType=0
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=6   and   iAlarmType=1
SELECT   count(*)   FROM   tbl_AlarmHistory   where   year(iResTime)=2006   and   month(iResTime)=6   and   iAlarmType=2
SELE