MSSQL (version 1.0.1)

tableNrow: Number of Rows

Description

Return the number of rows in a database table.

Usage

tableNrow(channel, sqtable)

Value

Number of rows as integer.

Arguments

channel

an RODBC connection.

sqtable

a database table or view.

See Also

tableDim and tableNcol also return the dimensions of a database table.

sqlQuery is the underlying function used to examine the table rows.

nrow is the base function to return the number of rows for data frames inside the R workspace.

MSSQL-package gives an overview of the package.

Examples

if (FALSE) {
con <- odbcConnect("myDatabase")

tableNrow(con, "sysusers")
}