sqlserver查询一个表有多少列

Question

select count(1) from syscolumns where id = object_id('tbname')

Answer 1

select * from syscolumns where id = object_id('tbname')

Answer 2

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

Answer 3

select count(name)from syscolumns where id=object_id('jobs')4

Answer 4

--and method
SELECT MAX(colid) FROM syscolumns WHERE id=OBJECT_ID('table')