Interested to Buy Any Domain ? << Click Here >> for more details...
how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 31044 Views
- Virtusa, I also Faced
- E-Mail Answers
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')
| Is This Answer Correct ? | 34 Yes | 8 No |
Post New Answer View All Answers
What kind of problems occurs if we do not implement proper locking strategy?
Explain optimistic and pessimistic concurrency?
Explain for xml explicit mode?
What are the dmvs? : sql server database administration
Explain the usage of floor function in sql server.
What is right outer join in sql server joins?
Explain what is scheduled job and how to create it?
Which is better statement or preparedstatement?
What is the difference between ddl and dml?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
What is de-normalization and what are some of the examples of it?
What is table-valued sub query?
How to make a column nullable?
Can I delete event logs?
What is a matrix in ssrs?
