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
- 17371 Views
- eFunds, I also Faced
- E-Mail Answers
Answer Posted / mathan
1.select count(*) from <table name>
2.select count_big(*) from <table name>
3.select rows from sysindexes where id=?
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is difference between clustered and non clustered index?
Where cross join is used?
Explain “@@rowcount” and “@@error” in sql server?
What is query cost in sql server?
What does ss stand for sexually?
What is normalization? Explain different forms of normalization?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What are the rendering extensions of ssrs?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
If we delete pack Spec what will be the status of pack Body ?
To which devices can a backup be created and where should these devices be located? : sql server management studio
How many categories of data types used by sql server?
How to join two tables in a single query in ms sql server?
What is sql server management studio? : sql server management studio
How to change a login name in ms sql server?
