1、查询一个表中有多少列
select count(1) from syscolumns where id = object_id('tbname')
2、查询一个表的所有列名
SELECT OBJECT_NAME(A.ID) TABLENM ,A.NAME COL FROM SYSCOLUMNS A WHERE OBJECT_NAME(A.ID) = 'IMPJMMONTHRPT_REAL201311'
1、查询一个表中有多少列
select count(1) from syscolumns where id = object_id('tbname')
2、查询一个表的所有列名
SELECT OBJECT_NAME(A.ID) TABLENM ,A.NAME COL FROM SYSCOLUMNS A WHERE OBJECT_NAME(A.ID) = 'IMPJMMONTHRPT_REAL201311'