count >
select-count

Select count(*) from aTable

算出共有几列资料

Count

SQL aggregate function

Select count(*) from aTable

Select count(Distinct Field) from aTable
rem: field= column name

SQL聚合函数

查出共有几列资料
若加上Distinct 则为不重复的数据列数

example 1
<%
SQL="Select count(*) from aTable"

set RS=conn.Execute(SQL)

RS("aColumnName")

%>

example 2
<%
SQL="Select count(file_name) as counts from "&Table&"  "
set RS=conn.Execute(SQL)

response.write "<hr>"&RS("counts")&"<hr>"
response.write "<hr>"&RS(0)&"<hr>"
%>