Answer Posted / dharmendra k. dixit

@Anshul..
Bro..through your code u can obtain the Total numbers of
rows in your Table.
---------------------------------

For getting Total Columns i will use this:

SELECT Count(*)As Coloumns
FROM Sys.SysColumns
Where ID =
(SELECT ID FROM Sys.SysObjects Where Name = 'YourTableName')

Explain system functions or built-in functions? What are different types of system functions?

929

---

How do I install only the client tools of sql server 2000?

1001

---

What is the Difference Between Primary and Foreign Key?

964

---

What happens on checkpoint?

978

---

What is the maximum size of a row in sql server?

920

---

What are the dis_advantages of stored procedures, triggers, indexes?

2184

---

Can one drop a column from a table?

979

---

What is the difference between a fill factor of 100 and 0?

927

---

What is sql collation?

1146

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

992

---

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1176

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

970

---

How to store and query spatial data?

942

---

What is the process of normalising?

959

---

Is it possible to have clustered index on separate drive from original table location?

919

---