查询一张表有多少列
select count(1) from syscolumns where id = object_id('TableName')
select * from syscolumns where id = object_id('TableName')
SELECT MAX(colid) FROM syscolumns WHERE id=OBJECT_ID('TableName')
select count(1) from syscolumns where id = object_id('TableName')
select * from syscolumns where id = object_id('TableName')
SELECT MAX(colid) FROM syscolumns WHERE id=OBJECT_ID('TableName')