COUNT函数：统计数据中有多少记录

意思：查询auser表中包含A的数据有多少条记录

Set rsf=Server.CreateObject("ADODB.Recordset")
sqlf="select COUNT(sid) as tj from auser where sid="&rs("uid")&""
rsf.open sqlf,conn,1,3

<%= rsf("tj") %>

查询：consultant(文本)这个字段为空的数据

sqlf="select COUNT(consultant) as tj from services where consultant=''"

查询：consultant(文本)这个字段为空而且是今天的数据

sqlf="select COUNT(consultant) as tj from services where consultant='' and datediff('d',addtime,now())=0"