Question

sqlserver 的 sql 语句中怎样查询表中有多少字段

Answer 1

可以通过如下语句得到当前Sql server中所有的数据的名称:
use master
select [name] from [sysdatabases] order by [name]
go
结果：
name
master
tempdb
model
msdb
BJQX_XLT
BJQX_LT
unicom
BJQX_CNET

Answer 2

select count(*) from syscolumns where id=object_id('表名')

Answer 3

use 库名
go
select COUNT(*) from syscolumns where id=(select id from sysobjects where name='库名')

Answer 4

SELECT COUNT(*) FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB')

Answer 5

select count(*) from table