Interested to Buy Any Domain ? << Click Here >> for more details...
Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table?
- 5 Answers
- 17370 Views
- eFunds, I also Faced
- E-Mail Answers
Answer Posted / ramakrishna
count()
@@rowcount
sysindexes
dbcc chektable
sp_spaceused
excution plan
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Define Joins?
Is truncate a dml command?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is 1nf normalization form?
How to create hyperlink from returned sql query ?
SQL Server Architecture ?
Can I use sql azure as a backup with log shipping or database mirroring?
What are the indexes in sql server?
Explain about integration services of Microsoft SQL server?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
How to make remote connection in database?
How to create a new schema in a database?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Which table keeps the locking information?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
