查询指定表里的字段数目

 select count(*) from syscolumns where id =(select id from sysobjects where name='Table_Name' and xtype='U')