Answer Posted / hokar
select count(*) from tablename.
| Is This Answer Correct ? | 27 Yes | 2 No |
Post New Answer View All Answers
What is a transactions?
Explain boyce and codd normal form(bcnf)?
What is cdc in sql server?
What is field in algebra?
Difference between connected and disconnected database in .net with sql server?
What is pivot and unpivot?
What is the dbcc command and why is it used?
explain databases and sql server databases architecture? : Sql server database administration
What is explicit cursors?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What are different types of statement?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is normalization? What number of normalization shapes are there?
Tell me what is use of except clause? How it differs from not in clause?
What are the different types of replication you can set up in sql server?