ASP implements a function to obtain the specified criteria row number for the MSSQL database table

This article mainly introduces the ASP to obtain the database table to specify the criteria for the number of functions of the function of the relevant data, need friends can refer to the

The code is as follows:
' Database table row number function, which is the number of rows to fetch the table
Function gettblrows (tblname)
' If the Tblname table name value is empty, the
If Tblname= "" Then
Gettblrows= "Unknown Tblname"
Exit Function
Else
Set rec = Server.CreateObject ("Adodb.recordset")
Sql= "EXEC sp_spaceused" &tblname
Rec.open sql,conn,1,1
Gettblrows=trim (Rec ("Rows"))
Rec.close
Set rec=nothing
End If
End Function

How to use it?

The code is as follows:
<%=gettblrows ("table name")%>

The above is the full content of this article, I hope you can enjoy.