Count(*) Function:
*requires db.asp
Code:
default.asp:
Highlight
<%option explicit%> <html> <!--#include file="_include/db.asp"--> <% Dim conn Dim rs Dim strSQL Dim sSQL strSQL = "exec sp_getCount" Set conn = ConnectSQLNT("DATABASE NAME", "SERVER NAME") Set rs = server.createobject("adodb.recordset") rs.open strSQL, conn %> <body> <%=rs("RecordCount")%> <% rs.close: set rs = nothing conn.close: set conn = nothing %> </body> </html>
sp_getCount:
Highlight
CREATE PROCEDURE dbo.sp_getCount AS select count(*) as RecordCount from TABLE NAME