如果xin表的ID是自增列，则
insert into xin(ENAME, SNAME, NEWNUM)
select MIN(ENAME) AS ENAME, SNAME, count(*) AS NEWNUM from jie group by SNAME
只要在asp代码中执行这个sql语句就可以了
首先，你要取出这个number
string.Format("SELECT COUNT(1) FROM jie AS a WHERE a.ENAME = '{0}' AND a.SNAME = '{1}'", ename, sname);
然后用这个number更新xin
string.Format("UPDATE xin SET NEWNUM = {0} WHERE ENAME = '{0}' AND SNAME = '{1}',number, ename, sname);
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024