查看数据库表中的列数

select count(name) from syscolumns where id=(select id from sysobjects where xtype='u' and name='TableName')