number of row of table in a data base

Question

0.00/5 (No votes)

See more:

what is the query that is used to count the number of rows of a table in a data base

Posted 27-Oct-12 8:27am

Updated 27-Oct-12 8:35am

v3

Comments

jackfrnz 27-Oct-12 14:31pm

what do you mean by "base table data" ?

2 solutions

count the number of rows of a table

SQL

SELECT COUNT(*) FROM myTable

Posted 27-Oct-12 8:38am

Comments

Mounayangui 27-Oct-12 14:55pm

i want to affect the number of the row in an integer variable

Sandeep Mewara 27-Oct-12 14:59pm

1. You comment is 'Not clear'.
2. Your question just asks for a query to find count.

adriancs 27-Oct-12 21:47pm

Yes, this query will return an integer.

adriancs 27-Oct-12 21:46pm

shot at target. vote 5

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mounayangui · Accepted Answer · 2012-11-03T09:34:00

SELECT COUNT(*) into nbr FROM myTable

Posted 3-Nov-12 9:34am