how to find number of columns in a table in sql server 2000
and 2005 also
- 7 Answers
- 13107 Views
- HCL, Virtusa, I also Faced
- E-Mail Answers
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
What are policy management terms?
What is the downside of using udf?
How many categories of functions based their return modes?
How to recreate an existing index in ms sql server?
Why we use trigger in sql server with example?
What do you mean by recursive stored procedure?
Can you type more than one query in the query editor screen at the same time?
wat wil hapn if we give the both read and deny read permission to user?
Explain what is it unwise to create wide clustered index keys?
What is the security principal at the database level that represents your session?
What is 2nf example?
What is difference between sql and sql server?
What is data source in connection string?
How to create a simple user defined function in ms sql server?
Why we use the openxml clause?
