DECLARE @TABLE_NAME SYSNAME = '[#table_name]',  --传入临时表名
        @TABLE_SCHEMA SYSNAME = N'[dbo]',
        @TABLE_CATALOG SYSNAME = N'[tempdb]'    
 
IF OBJECT_ID(@TABLE_CATALOG + N'.'+ @TABLE_SCHEMA + N'.' + @TABLE_NAME) IS NOT NULL
    PRINT(N'存在。')
ELSE
    PRINT(N'不存在。')

DECLARE @TABLE_NAME SYSNAME = '[#table_name]',      --传入临时表名
        @TABLE_SCHEMA SYSNAME = N'[dbo]',
        @TABLE_CATALOG SYSNAME = N'[tempdb]'    
 
IF EXISTS(SELECT TOP 1 1 FROM [tempdb].[dbo].[sysobjects] o WHERE o.[xtype] IN ('U') AND o.[id] = object_id(@TABLE_CATALOG + N'.'+ @TABLE_SCHEMA + N'.' + @TABLE_NAME))
    PRINT(N'存在。')
ELSE
    PRINT(N'不存在。')