有一个存储过程，求对应的asp

[victorli]

declare @i int
declare @year int
declare @month int
declare @day int
declare @Count int
set @i=0
set @year=2001
set @month=12
set @day=20
while @i<23
begin
select @Count=count(*) from server where day(VisitTime)=@day and month(VisitTime)=@month and year(VisitTime)=@year and DATENAME(Hour,VisitTime)=@i
set @i=@i+1
end
要输出@Count的值

[lanying]

没心思看,先up一下

[neweb]

TYear = 2001
TMonth = 12
TDay = 20
TDate = DateSerial(TYear,TMonth,TDay) '得到日期型变量
for i=0 to 23
strQ = "select count(*) from server where datediff(d,VisitTime,'" &TDate& "')=0 and DATENAME(Hour,VisitTime)="&I
set rs = conn.Execute(strQ)
response.write rs(0) & "<br>"
next

[jadesun]

@Count=count(*) 这样能行吗？

[jadesun]

要不你就直接写成select count(*) as number from server where day(VisitTime)=@day and month(VisitTime)=@month and year(VisitTime)=@year and DATENAME(Hour,VisitTime)=@i

然后ASP中用"EXEC sp_name @变量=值"传递过去执行

然后用rs读出来