sql求和存储过程该怎么写

set rs1=server.createobject("adodb.recordset")
sql1="select * from Task where ID='"&request("ID")&"'"
rs1.open sql1,conn,1,1
Notice=rs1("Notice")
Demand=rs1("Demand")
IsPay=rs1("IsPay")
rs1.close:set rs1=nothing

set piaoshu=server.createobject("adodb.recordset")
piaoshu.open "select * from idlist where TaskName='"&request("ID")&"'",conn,1,1
aaaapiaoshu=0
do while not piaoshu.eof
aaaapiaoshu=aaaapiaoshu+piaoshu("Success")
piaoshu.movenext
loop
piaoshu.close:set piaoshu=nothing


set rs=server.createobject("adodb.recordset")
sql="select * from Idlist where TaskName='"&request("ID")&"' and IdName = '"&request("IdName")&"'"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
Success=0
else
Success=rs("Success")
end if


----------------------
第一个是简单编号查询


第二个是求和，数据量比较大  Success字段(INT)


第三个也是编号和已成功查询

---

第二个：

piaoshu.open "select sum(success)as success from idlist where TaskName='"&request("ID")&