创维70寸电视价格:会ASP和SQL的人请进!

来源:百度文库 编辑:高校问答 时间:2024/05/05 13:34:52
请把以下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要用到&连接符,带入参数