怎么样才能取出统计数字？SQLSERVER问题

[zeybow]

我用ASP开发SQLSERVER，
sql="select user from mytbl compute count(user)"
set querydb=conn.Execute(sql)
怎么样才能把统计出来的用户数目取出并显示在页面上？

[xtra]

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")
根据你自己的情况做修改。。。。。。。。。。。。。。。。。。。

[华南虎哥]

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语句就行了

[zeybow]

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?

[xtra]

select count(name) as sCount from inpt2 where x between convert(datetime,date1,120) and convert(datetime,date2,120)

x 为你要比较的字段名称