怎么得出一个表中列的数量呢？
如题。

------解决方案--------------------
select count(1) from 表
------解决方案--------------------
select count(*) as 字段数量 from syscolumns where id=object_id( '表名 ')
------解决方案--------------------
select count(*) as 字段个数
from syscolumns
where id=object_id( '表名 ')
------解决方案--------------------
select count(列名) as 别名 from 表名
------解决方案--------------------

探讨

也对，可是，如果是想获得一个表有多少个字段怎么获得呢？

------解决方案--------------------
select count(*) from syscolumns 
where id = object_id( '表名 ')
------解决方案--------------------
select count(b.name) from sysobjects a,syscolumns b where a.id=b.id and a.name=tbname group by b.name
------解决方案--------------------

SQL code

select count(*) as column_count from syscolumns where id=object_id('table_name')

------解决方案--------------------
select   count(*)   as   字段数量   from   syscolumns   where   id=object_id( '表名 ')  


------解决方案--------------------
select   count(*)     as     字段个数  
from   syscolumns  
where   id=object_id( '表名')