请教SQL语句怎么写

[xjoil]

select name,
case when (select count(*) from name) >0
then '有'
else '无'
end as 临时表是否有数据
from tempdb.dbo.sysobjects where type='u' and name like '##%'

程序登录时建立了一个临时表，我想写条SQL语句查询出来临时表名和这张临时表里是否有记录。
如：
name 临时表是否有数据
00001 有
00002 有
00003 无

上面的语句第二行出错，找不到表名。请问该如何写？

[中国风]

这样用

SELECT  a.name ,
        CASE WHEN b.rows > 0 THEN '有'
             ELSE '无'
        END AS 临时表是否有数据
FROM    tempdb.dbo.sysobjects AS a
        INNER JOIN tempdb.dbo.sysindexes AS b ON a.id = b.id
                                                 AND b.indid IN ( 0, 1 )
WHERE   a.type = 'u'
        AND a.name LIKE '#%';
--AND a.name='指定临时表名'

[mingqing6364]

SELECT
	o.name,
	CASE p.ROWS WHEN 0 THEN '无' ELSE '有' END AS 临时表是否有数据
FROM
	tempdb.sys.partitions AS p
INNER JOIN
	tempdb.dbo.sysobjects AS o ON p.object_id = o.id
WHERE
	o.type = 'u'
AND o.name LIKE '##%'

[baidu_35289351]

#tb1________________________________________________________________________________________________________________00000000001B 临时表后面为什么要多这么多下划线？

[xjoil]

厉害！解决问题了，谢谢大家。