如何获得临时表的列数

Question

如题
SELECT COUNT(*) AS Expr1
FROM syscolumns
WHERE (id = OBJECT_ID('#temp'))
显示为0

Answer 1

SELECT COUNT(*) AS Expr1
FROM tempdb..syscolumns
WHERE (id = OBJECT_ID('tempdb..#temp')) 

Answer 2

SELECT COUNT(*) AS Expr1 
FROM tempdb.dbo.syscolumns 
WHERE (id = OBJECT_ID('tempdb.dbo.#T')) 

Answer 3

SELECT * FROM tempdb.dbo.syscolumns WHERE id=object_id('tempdb.dbo.#tmp')

Answer 4

呵呵~~
临时表是在TEMPDB下面的
OBJECT_ID('temp')　－>  OBJECT_ID('tempdb..#temp')

Answer 5

SELECT * FROM tempdb.dbo.syscolumns WHERE id=object_id('tempdb.dbo.#tmp')

Answer 6

临时表的信息，存放在 tempdb 中：select count(*) from tempdb.dbo.syscolumns where id = object_id('tempdb..#temp')

Answer 7

SELECT count(name) FROM tempdb.dbo.syscolumns WHERE id=object_id('tempdb.dbo.#a1')