Answer Posted / raghuram
the question is how do find number of rows in a table?
select count(*) from table_name
by using this we will get exact number of rows in a table.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is the function of sql server agent windows service?
How is foreign key related to primary key?
What is entity data services?
How to download microsoft sql server 2005 express edition?
how to trace the traffic hitting a sql server? : Sql server database administration
When do you think a developer should use sql server-based cursors?
What happens to a trigger with multiple affected rows?
what is spatial nonclustered index
What is a fill factor?
Can you index views?
What are the differences between char and nchar in ms sql server?
Explain something about security and SQL Azure?
How do clustered indexes store data?
How to specify the collation for a character data type in ms sql server?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?