sqlserver2008
获取所有字段:
获取表中字段个数:
获取所有字段:
select column_name from information_schema.columns where table_name='表名'
获取表中字段个数:
select count(name) from syscolumns where id=object_id('表名')