vbscript - VBS determine number of records in SQL table

Question

How do I determine the number of records in a SQL table and then save that value in variable?

Answer 1

Using ADO to access the db:

1. execute a simple SELECT count(0) FROM myTable query.
2. access the resultset (if not empty) and read the returned value.

Not tested code:

Dim conn, rs, recordsCount
recordsCount = -1

'initialize the connection
set conn = ...

'run the query and retrieve the results
set rs = conn.execute("SELECT count(0) as cnt FROM myTable")
if not rs.EOF then
  recordsCount = cint(rs("cnt"))
end if


'cleanup
rs.close
conn.close

set rs = nothing
set conn = nothing