select * from tempdb..sysobjects where name like '%#testvm%'

select * from tempdb.sys.objects where object_id = OBJECT_ID('tempdb.dbo.#testvm')

IF OBJECT_ID('tempdb..#YourTempTable') IS NOT NULL

IF OBJECT_ID('tempdb..#YourTempTable') <> 0

IF OBJECT_ID('tempdb..#YourTempTable') <> 0

select * from tempdb..sysobjects where name like '%#testvm%'

CREATE TABLE #testvm (RowID INT IDENTITY);

IF EXISTS (select * from tempdb..sysobjects where name like '%#testvm%') SELECT * FROM #testvm

SET NOCOUNT ON;
GO
if object_id('tempdb..#test') IS NOT NULL DROP TABLE #test;
create table #test (RowID INT IDENTITY PRIMARY KEY CLUSTERED);
select name from tempdb.sys.tables where name like '#test%';
GO 100