how to find number of columns in a table in sql server 2000
and 2005 also
- 16 Answers
- 27429 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / surbhi
SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS where
table_name='tablename'
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
when would you go for denormalization? : Sql server database administration
Tell me what is fill factor?
What do you mean by authentication modes in sql server?
What do you understand by mirroring and mention the advantages of the mirroring?
How do I view a stored procedure in sql server?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What are different types of database indexes?
What is report server project?
What is history table in sql server?
What is data modeling and Reterminal integrity?
Which are the two editions in which SQL Azure database available?
What type of Index will get created after executing the above statement?
Does a server store data?
How can I add Reporting Services reports to my application?
