怎么样才能取出统计数字？SQLSERVER问题
我用ASP开发SQLSERVER，
sql="select user from mytbl compute count(user)"
set querydb=conn.Execute(sql)
怎么样才能把统计出来的用户数目取出并显示在页面上？
问题点数：90、回复次数：4Top
1 楼xtra（）回复于 2000-09-07 17:40:00 得分 30
Sql="SELECT COUNT(DISTINCT User)UserCount FROM MyTbl"
Set QueryDb=Conn.Execute(Sql)
Response.Write QueryDb("UserCount")
或者：
Sql="SELECT COUNT(*)UserCount FROM MyTbl"
Set QueryDb=Conn.Execute(Sql)
Response.Write QueryDb("UserCount")
根据你自己的情况做修改。。。。。。。。。。。。。。。。。。。Top
2 楼hblinux（hblinux）回复于 2000-09-07 17:41:00 得分 30
Sql = "SELECT Count(*) as sCount FROM mytbl"
Set Rs = Conn.Execute(SQL)
if len(Rs("sCount"))>0 then
sCount = Rs("sCount")
else
sCount = 0
End If
'其中sCount就是所求的统计数,如果你统计的范围不一样,只需要修改Sql语句就行了Top
3 楼zeybow（郝强）回复于 2000-09-07 22:04:00 得分 0
select count(name) as sCount from inpt2 between convert(datetime,date1,120) and convert(datetime,date2,120)
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'between'.
/img/myquery.asp, 行148
how can i do it?
Top
4 楼xtra（）回复于 2000-09-07 22:24:00 得分 30
select count(name) as sCount from inpt2 where x between convert(datetime,date1,120) and convert(datetime,date2,120)
x 为你要比较的字段名称
Top
