column count in sql server code example Example: get number of table colums in sql query select count(*) from tablename