how to find number of columns in a table in sql server 2000 and 2005 also
select count (*) from tablename.