郯城电视台:会ASP和SQL的人请进!

来源:百度文库 编辑:中科新闻网 时间:2024/05/10 03:18:26
请把以下SQL 查询分析器语句转成ASP,谢谢,
select *
from CallNoUser
where startdate>'2006-07-02' and groupNo<>'softphe'
order by GroupNo
compute sum(ThisTime) by groupNo
包括输出这段查询内容的时候怎么输出!!!!

select *
from CallNoUser
where startdate>'#2006-07-02#' and groupNo<>'#softphe#'
order by GroupNo
compute sum(ThisTime) by groupNo

<input type=text name=indate>
然后SQL要用到&连接符,带入参数