select count(syscolumns.name)
from syscolumns , sysobjects
where syscolumns.id = sysobjects.id
and sysobjects.name =
‘表名‘
1.SQL统计某张表的列数。
原文：http://www.cnblogs.com/yxwkf/p/5111236.html
