学步园

热销产品统计程序

   
update bookinfo set IsHot=0

go
select top 5 BookID,sum(Num) '本数' into aa
from BuyInfo
group by BookID
order by sum(Num) DESC
go
update BookInfo
set IsHot=1
where BookID in
(
  select BookID
from aa
)
;

function Button1_onclick() {
       SqlConnection myConn = dbObj.GetConnection();
       String sql="select top 5 BookID,sum(Num) '本数' into aa  from BuyInfo";
       SqlCommand comm=new SqlCommand(sql,myConn);
       comm.ExecuteScalar();
        String sql1="update BookInfo set IsHot='1' where BookID in( select BookID from aa)";
       SqlCommand comm=new SqlCommand(sql1,myConn);
       comm.ExecutenNonQuery();
       myConn.close();
       }