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")&
相关问答：
小弟是个新手 现在有个问题一直不能解决
例如
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
C#如何判断连接sql server数据库成功？
try
{
connection.connect()
return true;
}
catch()
{
return false;
}
楼主很着急，开了几贴了。
引用
try
{
connection.connect( ......
