how to find number of columns in a table in sql server 2000 and 2005 also
Select Count(Column_Name) As NoOfColumns From Information_Schema.Columns Where table_Name='Company'