Question

请问怎么用SQL语句统计一个表有多少个字段？谢谢！

Answer 1

这个简单,用系统表就可以了,以数据库Northwind的Employees表为例,SQL语句如下:
use Northwind
select count(*) AS 字段数
from syscolumns
where id = (select id from sysobjects where name='Employees')

Answer 2

你要先说明你的数据库是SQL SERVER还是ORACLE还是ACCESS的,如果是ORACLE的应该是:
desc 表名

Answer 3

<%count=conn.execute("select count(*) from table")(0)%>在asp中这样

Answer 4

select count(*) as a from table

Answer 5

sp_columns @table_name = '表名'