how to find number of columns in a table in sql server 2000
and 2005 also
Answer Posted / kumar.t
Select Count(Column_Name) As NoOfColumns From
Information_Schema.Columns Where table_Name='Company'
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
How to filter records of table in SQL SERVER?
What are sql server functions?
Do you know the capabilities of cursors?
What is an indexing strategy?
Do you know what is a with(nolock)?
How do you delete duplicate rows in sql server?
What are the advantages of using third-party tools?
What command is used to create a database in the sql server and how?
How to turn on the mssql api module in php?
Explain the architecture of ms sql reporting service?
What are functions in the sql server?
What is the difference between substr and charindex in the sql server?
When multiple after triggers are attached to sql table, how to control the order of execution?
What are the differences between clustered and non-clustered index?
Equi join and non equi join is possible with sql server?