使用SQL语句可以查询某个表的所有列名:
SELECT name FROM syscolumns WHERE ID=OBJECT_ID('SQL表名');
也可以计算列的个数:
select count(name) FROM syscolumns WHERE ID=OBJECT_ID('SQL表名');