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
What is t-sql script to take database offline – take database online.
What is field with example?
what is a join and explain different types of joins? : Sql server database administration
What is microsoft sql server?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is the stuff?
How to update a field in SQL after ALTERING a row?
What is cross join in sql server joins?
Explain in details security in SQL azure?
How do I edit a procedure in sql server?
what is dbcc? : Sql server database administration
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How to connect to SQL Azure Database by using sqlcmd?
What is the difference between dropping a database and taking a database offline?
What are the different sql server versions?